All Episodes
Postgres FM — 179 episodes
PgQue
pg_wait_tracer
Schema design checklist
What’s Missing in Postgres?
Long-running transactions
PostGIS
Plan flips
pg_ash
Comments and metadata
PgDog update
RegreSQL
Postgres year in review 2025
Archiving
max_connections vs migrations
What's new in EXPLAIN
Tens of TB per hour
Gapless sequences
LWLocks
User management
Postgres 18
Gadget's use of Postgres
turbopuffer
When not to use Postgres
Disks
Multi-column indexes
Self-driving Postgres
caSe-inSENsiTive
Monitoring from Postgres AI
MultiXact member space exhaustion
Multigres
Multi-tenant options
Mean vs p99
What to log
How to move off RDS
Locks
Top ten dangerous issues
synchronous_commit
Managed service support
Time-series considerations
Performance cliffs
PgDog
Snapshots
GIN Indexes
Best Practices
Extended Statistics
SQL vs NoSQL
Return of the BUFFERS
Reads causing writes
NOT VALID constraints
pg_squeeze
pg_duckdb
RLS vs performance
jOOQ
Column Tetris
pg_stat_statements track_planning
Is pg_dump a backup tool?
Append-only tables
Denormalization
Postgres online communities
Advanced psql
Postgres Gotchas
Advanced EXPLAIN
Patroni
Postgres 17
Planning time
Slow count
Skip scan
Postgres Emergency Room
Get or Create
Getting started with benchmarking
Index-Only Scans
Why Postgres?
Compression
Out of disk
Postgres startup ecosystem
Four million TPS
Soft delete
Should we use foreign keys?
pgvectorscale
To 100TB, and beyond!
Sponsoring the community
Full text search
Minor releases
Custom vs generic plan
LIMIT vs Performance
Buffers II (the sequel)
Massive DELETEs
Logical replication common issues
Don't do this
Search
Health check
superuser
transaction_timeout
Rails + Postgres
Why isn't Postgres using my index?
Overhead of pg_stat_statements and pg_stat_kcache
Modern SQL
Bloat
pgvector
pgBadger
EXPLAIN
work_mem
Partitioning by ULID
Hash indexes
Constraints
Events
Subtransactions
Companion databases
Blue-green deployments
Data model trade-offs
Under-indexing
Over-indexing
Query hints
Stop and start Postgres faster
Backups
Postgres 16
Logical replication
Our favourite v16 feature
Connections
Decoupled storage and compute
Self-managing
Sharding
Data types
High availability
Beginner tips
Connection poolers
Anniversary mailbag
pg_upgrade: the tricky and dangerous parts
UUID
Memory
Extensions
Zero-downtime migrations
Parallelism
Corruption
ChatGPT x PostgreSQL
pg_stat_statements
auto_explain
Queues in Postgres
Read-only considerations
Partitioning
Peter Zaitsev
psql vs GUIs
Upgrades
Wait events
TOAST
JSON
Real-time analytics
Benchmarking
Default configuration
Infra cost optimization
Auditing
Copying a database
Transaction ID wraparound
Postgres year in review 2022
Row estimates
Replication
Timestamps
PostgREST
Materialized views
HOT updates
Database branching
Version control for databases
Contributing to Postgres
Stored procedures
PostgreSQL 15
102 Query optimization
Why is Postgres popular?
Index maintenance
Query macro analysis intro
WAL and checkpoint tuning
Intro to query optimization
How to become a DBA
Monitoring checklist
Vacuum
NULLs: the good, the bad, the ugly, and the unknown
BUFFERS by default
BRIN indexes
Managed services vs. DIY
Slow queries and slow transactions