"Scott Marlowe" <[email protected]> writes:
> On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
