Re: Startup process thrashing

"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