Postgres FM
Podcast image
Hash indexes
30 mins; December 15, 2023
Constraints
39 mins; December 08, 2023
Events
52 mins; December 01, 2023
Subtransactions
24 mins; November 24, 2023
Companion databases
45 mins; November 17, 2023
Blue-green deployments
43 mins; November 10, 2023
Data model trade-offs
38 mins; November 03, 2023
Under-indexing
34 mins; October 27, 2023
Over-indexing
42 mins; October 20, 2023
Query hints
35 mins; October 13, 2023
Stop and start Postgres faster
29 mins; October 07, 2023
Backups
43 mins; September 29, 2023
Postgres 16
39 mins; September 22, 2023
Logical replication
43 mins; September 15, 2023
Our favourite v16 feature
27 mins; September 08, 2023
Connections
28 mins; September 01, 2023
Decoupled storage and compute
42 mins; August 25, 2023
Self-managing
37 mins; August 18, 2023
Sharding
39 mins; August 11, 2023
Data types
37 mins; August 04, 2023
High availability
40 mins; July 28, 2023
Beginner tips
40 mins; July 21, 2023
Connection poolers
31 mins; July 14, 2023
Anniversary mailbag
31 mins; July 07, 2023
pg_upgrade: the tricky and dangerous parts
25 mins; June 30, 2023
UUID
22 mins; June 23, 2023
Memory
44 mins; June 16, 2023
Extensions
30 mins; June 09, 2023
Zero-downtime migrations
28 mins; June 02, 2023
Parallelism
44 mins; May 26, 2023
Corruption
42 mins; May 19, 2023
ChatGPT x 
PostgreSQL
35 mins; May 12, 2023
pg_stat_statements
45 mins; May 05, 2023
auto_explain
37 mins; April 28, 2023
Queues in Postgres
39 mins; April 21, 2023
Read-only considerations
39 mins; April 14, 2023
Partitioning
34 mins; April 07, 2023
Peter Zaitsev
43 mins; March 31, 2023
psql vs GUIs
31 mins; March 24, 2023
Upgrades
40 mins; March 17, 2023
Wait events
31 mins; March 10, 2023
TOAST
28 mins; March 03, 2023
JSON
31 mins; February 24, 2023
Real-time analytics
34 mins; February 17, 2023
Benchmarking
36 mins; February 10, 2023
Default configuration
32 mins; February 03, 2023
Infra cost optimization
28 mins; January 27, 2023
Auditing
35 mins; January 20, 2023
Copying a database
39 mins; January 13, 2023
Transaction ID wraparound
35 mins; January 06, 2023
Postgres year in review 2022
33 mins; December 30, 2022
Row estimates
31 mins; December 23, 2022
Replication
37 mins; December 16, 2022
Timestamps
26 mins; December 09, 2022
PostgREST
29 mins; December 02, 2022
Materialized views
41 mins; November 25, 2022
HOT updates
30 mins; November 18, 2022
Database branching
31 mins; November 11, 2022
Version control for databases
31 mins; November 04, 2022
Contributing to Postgres
33 mins; October 28, 2022
Stored procedures
35 mins; October 21, 2022
PostgreSQL 15
29 mins; October 14, 2022
102 Query optimization
31 mins; October 07, 2022
Why is Postgres popular?
31 mins; September 30, 2022
Index maintenance
32 mins; September 23, 2022
Query macro analysis intro
33 mins; September 16, 2022
WAL and checkpoint tuning
37 mins; September 09, 2022
Intro to query optimization
33 mins; September 02, 2022
How to become a DBA
32 mins; August 26, 2022
Monitoring checklist
27 mins; August 19, 2022
Vacuum
32 mins; August 12, 2022
NULLs: the good, the bad, the ugly, and the unknown
27 mins; August 05, 2022
BUFFERS by default
33 mins; July 29, 2022
BRIN indexes
36 mins; July 21, 2022
Managed services vs. DIY
32 mins; July 14, 2022
Slow queries and slow transactions
26 mins; July 05, 2022