1.2 Million Messages Per Second | Scaling Postgres 390

In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning.

Content Discussed

• Kafka is fast -- I'll use Postgres
• Temporal Joins
• Explaining IPC:SyncRep – Postgres Sync Replication is Not Actually Sync Replication
• Troubleshooting PostgreSQL Logical Replication, Working with LSNs
• Transaction pooling for Postgres with pgcat
• Returning Multiple Rows with Postgres Extensions
• Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.
• PostgreSQL 19: Two nice little improvements: log_autoanalyze_min_duration and search_path in the psql prompt
• pgfeaturediff
• Loading The Titanic Passenger Data Into PostgreSQL With DBeaver Part 2
• Part 2: PostgreSQL’s incredible trip to the top with developers
• Contributions for week 43, 2025
• Slonik on the Catwalk: PGConf.EU 2025 Recap
• Head of Marketing experiences @PGConf.EU 2025 – A Riga Recap
• The Future of CYBERTEC and PostgreSQL
• We Built a Production Agent (and Open-Sourced Everything We Learned)
• Fluid Storage: Forkable, Ephemeral, and Durable Infrastructure for the Age of Agents
• Fork First: Zero-Copy Postgres Forks That Make Friday Deploys Boring
• From ts_rank to BM25. Introducing pg_textsearch: True BM25 Ranking and Hybrid Retrieval Inside Postgres
• Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights
• AI-powered tuning tools for Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL databases: PI Reporter

YouTube Video

Podcast Audio