Scaling Postgres

In this episode of Scaling Postgres, we review two companies battling one another for text search dominance in Postgres, faster vector search with pg_vectorsearch, pushing Citus scaling with query routers and PostgreSQL 19 RC1 is released.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/439-text-search-battle-royale/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss performance improvements in ParadeDB as a result of PlanetScale, an open source BM25 index from PGX Inc., pgbouncer and pgvector patching and direct I/O benefits during backup.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/438-competition-is-good/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/437-reason-for-reversions/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/436-postgres-19-beta-4-released/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/435-postgres-19-revert-train/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/