Hacker News: dukepiki

New comment by dukepiki in "Database Traffic Control"

dukepiki — Thu, 02 Jul 2026 14:35:46 +0000

We know about Resource Governor and wanted to bring something as good or better to Postgres. SQL Server classifies whole sessions into a budget. Traffic Control classifies individual queries instead. That's better granularity, especially when a pooler multiplexes multiple different workloads into a session. It also opens up more flexible classification, e.g., based on query plan or based on sqlcommenter tags carrying information about client apps, job queues, priority levels, or release versions.

New comment by dukepiki in "Database Traffic Control"

dukepiki — Thu, 02 Jul 2026 05:22:28 +0000

Hi, I'm the lead engineer for Traffic Control. Glad to see it back in the news! If anyone's interested in more detail about how it works, check out https://planetscale.com/blog/behind-the-scenes-how-traffic-c..., or I'm happy to answer questions here.

New comment by dukepiki in "Pgrx: Build Postgres Extensions with Rust"

dukepiki — Tue, 28 Apr 2026 14:03:24 +0000

Last release was two weeks ago. pgrx is actively maintained.

New comment by dukepiki in "Pgrx: Build Postgres Extensions with Rust"

dukepiki — Tue, 28 Apr 2026 14:02:48 +0000

PlanetScale's internal extensions -- Insights, Traffic Control, and pg_strict -- are all built in pgrx.

Number of memory unsafety and race conditions I've had to debug in production in a year of use: zero.

pgrx is fantastic.

New comment by dukepiki in "Keeping a Postgres Queue Healthy"

dukepiki — Sun, 12 Apr 2026 05:08:38 +0000

MySQL’s concurrency control is a limit on the total number of threads that can be active at once, across all queries.

Traffic Control limits concurrency and resource use according to configurable metadata like the username, remote address, or the contents of any sqlcommenter tags included in the query. So you can say things like “the batch processing role can’t run more than four queries at a time.” The finer granularity is key.

New comment by dukepiki in "Behind the Scenes: How Database Traffic Control Works"

dukepiki — Mon, 23 Mar 2026 16:48:20 +0000

Hi, I'm the author of the post and the lead engineer on Traffic Control. Thanks for posting it here! Happy to answer questions anyone has.

New comment by dukepiki in "Postgres Traffic Control"

dukepiki — Mon, 23 Mar 2026 15:33:51 +0000

Lead engineer from Traffic Control here. Read more at https://planetscale.com/blog/behind-the-scenes-how-traffic-c... about how it works, or I'm happy to answer any questions here.

New comment by dukepiki in "$50 PlanetScale Metal Is GA for Postgres"

dukepiki — Mon, 15 Dec 2025 20:02:52 +0000

There's definitely a light mode for planetscale.com (the docs, the blog, the changelog, and the UI). Should work on both desktop and mobile. Make sure your browser is requesting light mode. The browser doesn't always follow your OS-level preferences.