100 Times Faster By Skipping! | Scaling Postgres 392
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount.
Content Discussed
- PostgreSQL 18: More performance with index skip scans
- #PostgresMarathon 2-012: Ultra-fast replica creation with pgBackRest
- #PostgresMarathon 2-013: Why keep your index set lean
- Postgres Internals Hiding in Plain Sight
- Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.
- PostgreSQL 19: Logical replication of sequences
- PgBouncer 1.25.0
- Did you know? Tables in PostgreSQL are limited to 1,600 columns
- AWS Performance Insights has been deprecated: What to know about CloudWatch Database Insights
- Postgres, Kafka and event queues
- Building a dev experience for Postgres in VS Code with Rob Emanuele
- The bastard DBA from hell
- PostgreSQL 19: The “WAIT FOR” command
- Using delayed read replicas for Amazon RDS for PostgreSQL disaster recovery
- PostgreSQL 18 - Temporal Constraints
- CloudNativePG 1.28.0 RC1 Released!
- pg_statviz 0.8 released with PostgreSQL 18 support
- Waiting for SQL:202y: GROUP BY ALL
- PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
- Loading The Titanic Dataset Into PostgreSQL With DBeaver Part 3
- PgPedia Week, 2025-11-02
- PgPedia Week, 2025-11-09
- Contributions for week 45, 2025
- Introducing Developer Tier for Aiven for PostgreSQL® services