hard20 pts · first answer countsreplicationpostgresql

Disk filling with WAL

The pg_wal directory on a PostgreSQL primary keeps growing until the disk is almost full. Archiving works. A replica was decommissioned last week. What is the most likely cause?

A.shared_buffers is set too highB.Autovacuum is running too oftenC.Too many indexes on large tablesD.An inactive replication slot left by the removed replica is forcing the primary to keep all WAL since that point

← Avoiding split-brain Two doctors go off call →