32 replies

Pgjs perf investigation

Hi @AJR, I saw in the Hyperdrive Changelog https://developers.cloudflare.com/hyperdrive/platform/changelog/#2024-05-22 that there were some driver performance improvements for postgres.js. However, I’m testing a hyperdrive connection using a worker and am finding that with caching enabled and

{ "prepare": true }

{ "prepare": true }

I get 100% cache misses on a simple SELECT like

const [user]: [User?] = await sql`SELECT * FROM users WHERE id = ${userId}

const [user]: [User?] = await sql`SELECT * FROM users WHERE id = ${userId}

;. If I set

{ “prepare”: false }

{ “prepare”: false }

then latency improves, I get some cache hits but the majority are marked as uncacheable on the same repeated query. Any help is greatly appreciated, (happy to DM my connection id) - thanks.

Cloudflare Docs

Changelog · Hyperdrive

You can now create up to 25 Hyperdrive configurations per account, up from the previous maximum of 10.

Cloudflare Developers•2y ago•

32 replies

elliott

Pgjs perf investigation

{ "prepare": true }

{ "prepare": true }

I get 100% cache misses on a simple SELECT like

const [user]: [User?] = await sql`SELECT * FROM users WHERE id = ${userId}

const [user]: [User?] = await sql`SELECT * FROM users WHERE id = ${userId}

;. If I set

{ “prepare”: false }

{ “prepare”: false }

then latency improves, I get some cache hits but the majority are marked as uncacheable on the same repeated query. Any help is greatly appreciated, (happy to DM my connection id) - thanks.

Cloudflare Docs

Changelog · Hyperdrive

You can now create up to 25 Hyperdrive configurations per account, up from the previous maximum of 10.

Pgjs perf investigation

Similar Threads

Pgjs perf investigation

Similar Threads

Similar Threads

Similar Threads