"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> AFAIK the only non-PITR reason for WAL files to not get recycled is if >> checkpoints were failing. Do you still have the postmaster log from >> before the original crash, and if so is there anything in there about >> checkpoint failures? > Don't forget that the OP mentioned earlier that he had very long help > open connections with possible long help open transactions. Open transactions don't prevent checkpoints and thus not WAL truncation either. You're confusing this with vacuuming. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
