PostgreSQL Videos, Tutorials & DBA Guides

Why is my PostgreSQL query slow? (Version 19 Fix)

July 13, 2026

Your query is slow. But WHERE is it slow? PostgreSQL 19 finally tells you.

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

July 13, 2026

You have 16 cores. PostgreSQL uses 1. Sound familiar?

PostgreSQL work_mem: The Hidden 400GB RAM Bomb

July 2, 2026

You set work_mem to 1GB. Reasonable, right? Wrong.

Your PostgreSQL work_mem Is a 400 GB Memory Bomb

June 26, 2026

One line of config. Up to 400 GB of RAM. On a server with 128.

PostgreSQL 19: Join Planner Stats by OID (Finally)

June 25, 2026

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

PostgreSQL 19: Stop Guessing Which Table Needs VACUUM

June 24, 2026

Which table is bloated? Before PG19, you had to guess. Not anymore.

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)

June 21, 2026

JIT compilation was on by default. It caused more problems than it solved.

128 GB RAM. 18-Second Query. Here's Why Hardware Won't Save You.

June 20, 2026

You threw hardware at the problem. It didn't work. Here's why.

"Max Out the Hardware" Is Wrong Advice. Here's Why.

June 15, 2026

Someone told you to max out shared_buffers. They were wrong.

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

June 15, 2026

128 GB of RAM. 32 cores. NVMe storage.

New to PostgreSQL? Start Here. (2026 DBA Roadmap)

June 12, 2026

You want to learn PostgreSQL. The internet has 10,000 tutorials. Where do you start?

The work_mem Formula That Prevents OOM Crashes (With Math)

June 9, 2026

128 GB RAM. work_mem at 64 MB looks safe.

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

June 4, 2026

You upgraded to PostgreSQL 19. Now nobody can log in.

PostgreSQL 19: Graph Queries and GROUP BY ALL Changed Everything

June 3, 2026

SQL/PGQ graph queries. GROUP BY ALL. PostgreSQL 19 is a game changer.

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).

Your Table Is 80% Dead Rows. VACUUM Won't Save You.

PostgreSQL tutorial covering Your Table Is 80% Dead Rows. VACUUM Won't Save You..

From 47 Seconds to 3.6ms: The Query Fix That Changed Everything

PostgreSQL tutorial covering From 47 Seconds to 3.6ms: The Query Fix That Changed Everything.

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..

5 Reasons Senior Engineers Choose PostgreSQL Over MySQL

PostgreSQL tutorial covering 5 Reasons Senior Engineers Choose PostgreSQL Over MySQL.

Stop Guessing. Here's How to Benchmark PostgreSQL Properly.

PostgreSQL tutorial covering Stop Guessing. Here's How to Benchmark PostgreSQL Properly..

Dead Tuples Are Silently Killing Your PostgreSQL (Here's Proof)

PostgreSQL tutorial covering Dead Tuples Are Silently Killing Your PostgreSQL (Here's Proof).

Your PostgreSQL Is Gone. You Have One Option Left.

PostgreSQL tutorial covering Your PostgreSQL Is Gone. You Have One Option Left..

The Index That Made My Query 1000x Faster (PostgreSQL Indexing Secrets)

PostgreSQL tutorial covering The Index That Made My Query 1000x Faster (PostgreSQL Indexing Secrets).