"Scott Marlowe" <scott.marl...@gmail.com> writes:
> On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane <t...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
