"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane <tgl@sss.pgh.pa.us> 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