Are You Hurting Your Performance? | Scaling Postgres 371
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods.
Content Discussed
- SELECT FOR UPDATE considered harmful in PostgreSQL
- Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text Search
- The (Non-) Effect of Primary Keys on Bulk Data Load Performance
- PostgreSQL and Ducks: The Perfect Analytical Pairing
- PostgreSQL active-active replication, do you really need it?
- Preserve optimizer statistics during major upgrades with PostgreSQL v18
- How I Dropped the Production Database on a Friday Night
- Mean vs p99
- PGConf.dev 2025 YouTube Playlist
- Speed Without Sacrifice: Building the Modern PostgreSQL for the Analytical and Agentic Era
- CNPG Recipe 19 – Finer Control Over Postgres Startup with Probes
- Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL
- Handling BLOBs in PostgreSQL Part 2
- Nisha Moond
- PgPedia Week, 2025-06-15
- Contributions for the week of 2025-06-02 (Week 23)
- PostgreSQL Logical and Physical Replication Comparison and the Advantages of Distributed PGD
- Blocked Bloom Filters: Speeding Up Point Lookups in Tiger Postgres' Native Columnstore
YouTube Video
Podcast Audio
