Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates

The article examines why PostgreSQL tables often retain large disk footprints after massive inserts, updates, and deletions, showing experiments on PG 13/PG 14, analyzing factors such as long‑running transactions, replication slots, uncommitted transactions, fillfactor settings, and the old_snapshot_threshold bug, and offering practical diagnostics and mitigation steps.

Vacuumfillfactorold_snapshot_threshold

0 likes · 8 min read

Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates

JD Cloud Developers

Sep 21, 2022 · Databases

Unlocking PostgreSQL Logical Replication: Principles, Challenges, and Cloud Migration

This article explains PostgreSQL logical replication concepts, key components like replication slots and output plugins, common challenges such as failover slots, DDL sync, and bidirectional loops, and demonstrates practical full‑and‑incremental data migration to the cloud.

DDL SyncData MigrationLogical Replication

0 likes · 9 min read

Unlocking PostgreSQL Logical Replication: Principles, Challenges, and Cloud Migration

Qunar Tech Salon

Nov 5, 2020 · Databases

Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution

This article explains why a low‑traffic PostgreSQL 11 database can accumulate massive WAL files, analyzes relevant configuration parameters and replication slots, demonstrates diagnostic SQL commands, and provides step‑by‑step actions—including adjusting archive_timeout, handling replication slots, and forcing a checkpoint—to reclaim disk space.

Database AdministrationWALperformance tuning

0 likes · 8 min read

Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution