Hacker News new | ask | show | jobs
by pkhuong 1399 days ago
I've seen the WAL grow when there's a constant write load and a long background read transaction keeps an old version alive. If you also never reach a point where there are 0 connections to the DB, you can keep this large WAL file around (most of it is unused) for a long time.

I've had to restart services when WAL files had grown to multiple GBs and wouldn't shrink.