Darick
CDCloudflare Developers
•Created by AJR on 5/14/2024 in #hyperdrive
Postgres.js with default settings doesn'
Got it. Thank you for the explanation! 🙏
9 replies
CDCloudflare Developers
•Created by AJR on 5/14/2024 in #hyperdrive
Postgres.js with default settings doesn'
I see. And if I understanding correctly, that penalty is not incurred for subsequent queries on that connection? (What is not clear to me is how the library keeps track of this when there may be multiple connections in its internal connection pool ...)
9 replies
CDCloudflare Developers
•Created by AJR on 5/14/2024 in #hyperdrive
Postgres.js with default settings doesn'
node-postgres uses text format in its describe messages, so it doesn't need to do the initial *parse-describe-flush" sequence for type inference. This saves a roundtrip that we cannot cache todayInteresting. To be clear, even if we select
prepare: false
, does postgres.js incur more roundtrips per query?9 replies
CDCloudflare Developers
•Created by AJR on 5/14/2024 in #hyperdrive
Postgres.js with default settings doesn'
For right now if you want to try testing again using node-postgres for best performance that's the best bet. You can also use prepare: false when setting up your connection with postgres.js to help ameliorate some of the performance penalty.Tangentially (unrelated to Hyperdrive), I'd love to know more about node-postgres vs postgres.js. With
prepare: false
, should we expect comparable performance between the two libraries, or are there other pros / cons of each library?9 replies
CDCloudflare Developers
•Created by Hello, I’m Allie! on 2/27/2024 in #kv
You can't configure the KV origins. As
(@Unsmart, I would appreciate any insight / experience you have here too. Thank you.)
8 replies
CDCloudflare Developers
•Created by Hello, I’m Allie! on 2/27/2024 in #kv
You can't configure the KV origins. As
For back of the envelope estimates, let's say we run a DO as a drop-in-ish replacement for KV, where we just ask it to fetch and store batches of values opaquely, with minimal to no processing of those values. Is there a ballpack throughput for
(1) values < 1K, and
(2) values ~100k?
(Happy to be pointed to existing documentation too, if that's easier)
8 replies
CDCloudflare Developers
•Created by Hello, I’m Allie! on 2/27/2024 in #kv
You can't configure the KV origins. As
Thank you. That is an option we're considering too.
The concern is funneling access to the data through a single (DO) process, and when that might reach a scalability limit. Is that concern overblown?
8 replies