Competition Is Good | Scaling Postgres 438

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.

Content Discussed

• PlanetScale Released Text Search and We Have a Lot to Say (Part I)
• pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index
• Nobody Patches the Pooler
• The Vector That Lied About Its Dimensions
• What is direct I/O, and why does ClickHouse Managed Postgres use it for backups?
• Consolidating databases with Postgres logical replication
• Everyone into the Pool
• The Deep End
• I ran the same query twice and Postgres disagreed with itself
• Query plan rewriting in PostgreSQL
• I timed 179 index recommendations on real data. 18% made the query slower.
• Vectorized Query Execution in PostgreSQL 19: Arrow, ORCA and Flight SQL in a PostgreSQL Extension
• Contributions for week 39
• Designing Neki for performance
• Introducing Dedicated Read Replicas for Postgres
• What today's software owes to Bronze Age clocks
• Scale without limits: Multigres, OrioleDB, and dbarena
• How to integrate JFrog Artifactory with Fujitsu Enterprise Postgres
• Stop Hardcoding Image Tags: How CNPG Image Catalogs Streamline PostgreSQL Fleet Upgrades

YouTube Video

Podcast Audio