Blogsby GlyphMassively parallel Postgres backups
PlanetScale backs up petabyte-scale sharded Postgres databases in hours using parallel infrastructure, object storage, and WAL replay.
7 of 800 posts
Fri Jul 311 post
Fri Jul 241 post
Postgres backups under the hood
With backups being such a vital part of keeping your data safe, how do they actually work?
Thu Jul 231 post
What's new in Postgres 19
`VACUUM` reclaims dead-tuple space but doesn't shrink a table. PostgreSQL 19 Beta 2 adds an in-core online rewrite with REPACK (CONCURRENTLY), and much more.
Mon Jul 201 post
Every UPDATE Leaves a Ghost: MVCC, Bloat, and VACUUM in PostgreSQL
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.
Wed Jul 151 post
Making 768 servers look like 1
How to make 768 distinct Postgres servers look like 1 to your applications.
Mon Jul 131 post
When the Postgres query planner goes rogue
How PlanetScale Database Traffic Control contained a runaway Postgres query after the planner abandoned an index.
Wed Jul 81 post
Deadlocks and downtime
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.