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
·2 месяца назад·discuss
Last release was two weeks ago. pgrx is actively maintained.
dukepiki
·2 месяца назад·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.