Seven Years of Scaling Postgres | Scaling Postgres 350
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics.
Content Discussed
- A New Postgres Block Storage Layout for Full Text Search
- Anatomy of table-level locks: Reducing locking impact
- NOT VALID constraints
- GROUP BY: Fixing optimizer estimates
- January Meetup: “Who needs Kafka?”
- PostgreSQL 18: Add OLD/NEW support to RETURNING in DML queries
- Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default
- How to Test Your PostgreSQL Connection
- Logical replication in Postgres: Basics
- Who Contributed to PostgreSQL Development in 2024?
- PostgreSQL Hacking Workshop - February 2025
- Mastering Logical Replication
- Unpivoting data using JSONB
- Implementing thread-safe scanners and parsers in PostgreSQL
- Whose optimisation is better?
- The importance of testing with not-so-usual setups
- Don't forget about the Postgres parallel leader participation setting
- Contributions for the week of 2025-01-13 (Week 3 overview)
- PgPedia Week, 2025-01-19
- Postgresql at FOSDEM 2025
- Open Day 2025 in Bolzano (Italy): schedule available
- How to Optimize PostgreSQL Cloud Costs With Tiered Storage
YouTube Video
Podcast Audio
