HackerTrans
TopNewTrendsCommentsPastAskShowJobs

dukepiki

no profile record

comments

dukepiki
·قبل 10 أيام·discuss
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.
dukepiki
·قبل 10 أيام·discuss
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.
dukepiki
·قبل شهرين·discuss
Last release was two weeks ago. pgrx is actively maintained.
dukepiki
·قبل شهرين·discuss
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.
dukepiki
·قبل 3 أشهر·discuss
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.
dukepiki
·قبل 4 أشهر·discuss
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.
dukepiki
·قبل 4 أشهر·discuss
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.
dukepiki
·قبل 7 أشهر·discuss
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.