PostgreSQL Videos, Tutorials & DBA Guides

Amazon Aurora PostgreSQL: What Really Happens When It Fails?

August 12, 2026

How does Amazon Aurora PostgreSQL actually work in production, and what happens when the writer, an Availability Zone, or an entire Region fails?

PostgreSQL Active-Active Across 3 Regions | Production HA

August 10, 2026

PostgreSQL active-active / multi-master: how production multi-region write architectures really fail.

PostgreSQL on Amazon RDS: What Happens When It Fails?

August 7, 2026

Amazon RDS PostgreSQL: I Built & Broke Every Production Architecture

PostgreSQL: 16 Cores. This Query Uses One

August 5, 2026

PostgreSQL parallel query tip: 16 cores mean nothing if EXPLAIN shows no Gather.

PostgreSQL HA Architecture: Surviving a Full Region Failure

August 4, 2026

Three writable PostgreSQL regions. One region dies. Writes continue.

PostgreSQL Chose the Index. The Query Took 3.2× Longer

August 3, 2026

An index does not automatically make every PostgreSQL query faster.

500 PostgreSQL Connections, Only 20 Active? Fix It with PgBouncer

August 3, 2026

Your PostgreSQL server may show hundreds of connections while only a small number are actively running queries.

PostgreSQL High Availability: Build, Break & Fix Patroni + etcd

July 29, 2026

PostgreSQL high availability: Patroni, failover, and the failure drills that prove HA works.

500 PostgreSQL Connections, 470 Idle: Fix This Before Production Slows

July 19, 2026

PostgreSQL connections and PgBouncer: fix idle connection storms before production slows.

PostgreSQL Uses 1 of 16 CPU Cores. Here's the Fix.

July 13, 2026

Your PostgreSQL server has 16 CPU cores, but your slow query uses only one. The other 15 sit idle while your query crawls.

PostgreSQL work_mem: The Setting That Crashed My 400GB Server

July 2, 2026

PostgreSQL work_mem math: 1GB x connections x operations can demand 400GB RAM.

Your PostgreSQL work_mem Is a 400 GB Memory Bomb

June 26, 2026

PostgreSQL work_mem can silently demand hundreds of GB and OOM your server.

PostgreSQL 19: The Join Stat Fix We Waited 10 Years For

June 25, 2026

Debugging the planner just got easier. PostgreSQL 19 makes stats joinable.

PostgreSQL 19: Finally See Which Tables Need VACUUM (New Feature)

June 24, 2026

PostgreSQL 19 shows which tables need VACUUM — no more guessing at bloat.

PostgreSQL 19: Lock Waits Are Finally Visible (After Years)

June 22, 2026

"Why is my query waiting?" PostgreSQL 19 finally answers this.

PostgreSQL 19: JIT Is OFF by Default (And That's Good)

PostgreSQL tutorial covering PostgreSQL 19: JIT Is OFF by Default (And That's Good).

Your PostgreSQL Server Is Not Maxed Out. These 5 Settings Are Wrong.

PostgreSQL tutorial covering Your PostgreSQL Server Is Not Maxed Out. These 5 Settings Are Wrong..

PostgreSQL DBA in 2026: The Complete Roadmap (Start Here)

PostgreSQL tutorial covering PostgreSQL DBA in 2026: The Complete Roadmap (Start Here).

PostgreSQL 19 Broke Your Login. Here's the Fix.

PostgreSQL tutorial covering PostgreSQL 19 Broke Your Login. Here's the Fix..

PostgreSQL 19: Graph Queries and GROUP BY ALL Changed Everything

PostgreSQL tutorial covering PostgreSQL 19: Graph Queries and GROUP BY ALL Changed Everything.

PostgreSQL 19: Read-Your-Writes on Replicas (Zero Performance Hit)

PostgreSQL tutorial covering PostgreSQL 19: Read-Your-Writes on Replicas (Zero Performance Hit).

PostgreSQL 19: Faster Performance, Zero Config Changes Required

PostgreSQL tutorial covering PostgreSQL 19: Faster Performance, Zero Config Changes Required.

PostgreSQL 19 Autovacuum: Settings That Finally Prevent Bloat

PostgreSQL tutorial covering PostgreSQL 19 Autovacuum: Settings That Finally Prevent Bloat.

PostgreSQL 19: Sequences Finally Replicate (After 20 Years)

PostgreSQL tutorial covering PostgreSQL 19: Sequences Finally Replicate (After 20 Years).

PostgreSQL Table Bloat: VACUUM Won't Save You

PostgreSQL tutorial covering PostgreSQL Table Bloat: VACUUM Won't Save You.

PostgreSQL: From 47 Seconds to 3.6ms Query Fix

PostgreSQL tutorial covering PostgreSQL: From 47 Seconds to 3.6ms Query Fix.

Checkpoints Are Killing Your PostgreSQL Performance

PostgreSQL tutorial covering Checkpoints Are Killing Your PostgreSQL Performance.

PostgreSQL Replication Commands That Save Production

PostgreSQL tutorial covering PostgreSQL Replication Commands That Save Production.

PostgreSQL Backup Commands You Need Before Disaster Strikes

PostgreSQL tutorial covering PostgreSQL Backup Commands You Need Before Disaster Strikes.

3 Ways to Upgrade PostgreSQL Without Destroying Production

PostgreSQL tutorial covering 3 Ways to Upgrade PostgreSQL Without Destroying Production.

EXPLAIN ANALYZE: Read PostgreSQL Query Plans Like a Senior DBA

PostgreSQL tutorial covering EXPLAIN ANALYZE: Read PostgreSQL Query Plans Like a Senior DBA.

MySQL to PostgreSQL: The Migration Nobody Warns You About

PostgreSQL tutorial covering MySQL to PostgreSQL: The Migration Nobody Warns You About.

Oracle to PostgreSQL: The Migration That Saved My Company $2M/Year

PostgreSQL tutorial covering Oracle to PostgreSQL: The Migration That Saved My Company $2M/Year.

Your PostgreSQL Has a Backdoor. Here's How to Find It.

PostgreSQL tutorial covering Your PostgreSQL Has a Backdoor. Here's How to Find It..