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