Latest Episodes
415
pgBackRest Is Dead? | Scaling Postgres 415
In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum...
414
Repack Concurrently | Scaling Postgres 414
In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing...
413
Shard With One Command | Scaling Postgres 413
In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata...
412
Half as Fast on Linux 7 | Scaling Postgres 412
In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is...
411
Absorbing Load | Scaling Postgres 411
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and...
410
Postgres Traffic Cop! | Scaling Postgres 410
In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration...