Novel Partition Exclusion | Scaling Postgres 425

In this episode of Scaling Postgres, we discuss excluding partitions without using a partition key, a pgBackRest interview, Postgres backup without an incremental chain and a replication deadlock bug in Postgres 14-16.

Content Discussed

• How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
• pgBackRest
• Why pg_hardstorage has no incremental chain
• Replication Deadlock Bug in Current Postgres Releases 14-16
• Are You .ready?
• My Dishonest Benchmark
• OrioleDB beta15 and beta16: stability, testing, and replication hardening
• Why we built yet another Postgres connection pooler
• VACUUM at the Page Level
• Looking Forward to Postgres 19: Checksums For All
• Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.
• Waiting for PostgreSQL 20 – Add backend-level lock statistics
• Happy 30th Birthday, PostgreSQL
• Postgres Transactions are a Distributed Systems Superpower
• Following a Backup from PostgreSQL to Recovery using pg_hardstorage
• Highly Available, Load-Balanced PostgreSQL with Patroni, HAProxy, and Keepalived
• Jumping the gun: looking ahead at PostgreSQL 19
• Deadlocks and downtime
• CNPG Recipe 25 - Declarative Roles and Passwordless TLS in CloudNativePG 1.30
• Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology
• PostgreSQL Disaster Recovery with pgBackRest TLS Transport
• LOAD "PL/CBMBASIC",8,1: Commodore 64 BASIC for PostgreSQL
• Estonia PUG Meetup
• PG DATA 2026 recap, and looking forward to PG DATA 2027
• Meeting in Montreal: Developer U plan(ner) patches
• EDB heads to PGConf.Brasil 2026, this is what we’ll be talking about!
• Inaugural PostgreSQL Istanbul Meetup was a blast!
• How to Build a RAG Server on pgEdge Cloud via the API
• The Data Layer for the AI Data Center
• AI's Physical Constraints: How AI Rewired the Data Center
• Searchable field-level encryption on Supabase with CipherStash
• Logical replication improvements in Amazon RDS for PostgreSQL 18
• Automate PostgreSQL audit log extraction and analysis with Amazon S3

YouTube Video

Podcast Audio