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: 13
Reviews: 0
Episodes: 94

Description

A weekly podcast about all things PostgreSQL

Episode Date
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