Native Column Store? | Scaling Postgres 378

In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive.

Content Discussed

• A journey toward the Columnar Data Store
• btree_gist improvements in PostgreSQL 18
• Scaling Postgres LISTEN/NOTIFY
• High Availability and Postgres full-sync replication
• "enable" parameters will work differently in Postgres 18
• Postgres Replication Slots: Confirmed Flush LSN vs. Restart LSN
• Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN
• Optimising Cold Page Reads in PostgreSQL
• Graviton2 versus Graviton4
• Squeezing out Postgres performance on RTABench Q0
• Extra approach to RTABench Q0 optimisation
• Do You Know The LATERAL JOIN In SQL?
• Stack traces for Postgres errors with backtrace_functions
• Book Review - Mastering PostgreSQL 17
• Data Security and AI - Sharing Your PostgreSQL Database With Ollama AI
• No, you don't necessarily need extensions to compact Postgres tables
• Exploration: PostgreSQL Cluster Backup with Barman(CNPG)
• When PostgreSQL performance slows down, here is where to look first
• Shlok Kumar Kyal
• Contributions for the weeks 30 & 31 (2025-07-21 to 2025-08-03)
• PgPedia Week, 2025-07-20
• Speed Without Sacrifice: 9000x Faster High Performance Ingestion, 42x Faster DELETES, Improved CAgg Updates and More in TimescaleDB 2.21
• 42× Faster DELETEs: Accelerating Analytics and High-Volume Ingestion with TimescaleDB 2.21
• Tiger Powers Julep’s AI Platform with Postgres-Native Infrastructure for Scalable Memory, Real-Time Reasoning, and Multi-Step Task Automation

YouTube Video

Podcast Audio