Blog
Ahmed Darwich [@AhmedDarwich] |
Postgres 19 switches TOAST compression from pglz to LZ4. LZ4 is faster, but it isn't always smaller, and some reads get slower with it. →
Patrick Reynolds, Eric Ridge |
TIN v1.0.6 supports stemming in 18 languages and is 2-3x as fast as the GA version →
Simeon Griggs [@simeonGriggs] |
Admission controls in software determine what does or doesn't happen next, and the most common implementation has ancient roots. →
Etienne Berube, Nick Holden, Chris Sinjakli |
Use dedicated read replicas to isolate read-only workloads and distribute your data across data centers around the world. →
Simeon Griggs [@simeonGriggs] |
What makes a good sharding strategy today might not work so well tomorrow. What happens when you have one tenant hitting your database orders of magnitude more than any other? Or product managers knocking down your door with new requirements? If you're already on Neki, fortunately these are issues we can solve. →
Ahmed Darwich [@AhmedDarwich] |
ARM and x86 can give you different performance at the same vCPU count. Here's what differs, what to measure, and how to choose. →
A good Postgres search demo was doing the rounds online. Let's see what happens when we upgrade it to TIN. →
Andres Taylor, Harshit Gangal, Ahmed Darwich [@AhmedDarwich] |
A Neki router gives applications a Postgres connection to one database while planning and coordinating queries across the shards behind it. →
Simeon Griggs [@simeonGriggs] |
Unblock stuck connections with live connection management in the PlanetScale CLI and dashboard →
Simeon Griggs [@simeonGriggs] |
Postgres presents pretty predictable performance problems when dealing with large tables. Sharding solves this. →
Josh Brown [@imjosh] |
Why has it taken so long to get good Postgres sharding? The last 20 years are the answer. →
Josh Brown [@imjosh] |
An engineer's worst nightmare is waking up to a seemingly read-only database with no clear issue in sight. Let's dig into why this happens, and how AI can help solve it. →
Harshit Gangal, Ahmed Darwich [@AhmedDarwich] |
A data topology describes the sharding scheme a Neki router uses to map logical PostgreSQL tables to physical shards and route queries. →
Jan Nidzwetzki, Etienne Berube |
Subtransactions can slow down your entire PostgreSQL server and break your high availability strategy by keeping new read replicas from accepting connections. →
PlanetScale backs up petabyte-scale sharded Postgres databases in hours using parallel infrastructure, object storage, and WAL replay. →
Josh Brown [@imjosh] |
With backups being such a vital part of keeping your data safe, how do they actually work? →
Ahmed Darwich [@AhmedDarwich] |
`VACUUM` reclaims dead-tuple space but doesn't shrink a table. PostgreSQL 19 Beta 4 adds an in-core online rewrite with REPACK (CONCURRENTLY), and much more. →
Jan Nidzwetzki, Etienne Berube, Ahmed Darwich [@AhmedDarwich] |
What happens to old row versions after nobody needs them? They become dead tuples, and over time they bloat your tables. Go deeper into PostgreSQL MVCC with runnable psql examples. →
How to make 768 distinct Postgres servers look like 1 to your applications. →
Nick Van Wiggeren [@NickVanWig] |
How PlanetScale Database Traffic Control contained a runaway Postgres query after the planner abandoned an index. →
Simeon Griggs [@simeonGriggs] |
Deadlocks happen when transactions block each other. Learn how they escalate into downtime, how to reduce them through better queries and retry logic, and how Traffic Control can protect your database from your application. →
Simeon Griggs [@simeonGriggs] |
Yo, I heard you liked databases, so we put logical databases in your database cluster so you can database while you database →