Re: BUG #2104: pg_xlog/ trace files not reclaimed by server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Reuben Pasquini" <pasquini(at)imageworks(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2104: pg_xlog/ trace files not reclaimed by server
Date: 2005-12-09 16:31:36
Message-ID: 13761.1134145896@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Reuben Pasquini" <pasquini(at)imageworks(dot)com> writes:
> It appears that when my 8.1 database is forced
> to generate more than
> 2*checkpoint_segments + 1
> trace files under pg_xlog/, that the database
> becomes confused and stops recycling the trace files.

That's fairly hard to believe, especially since you haven't presented
any actual evidence of it.

What might have happened is that checkpoints were failing for some
reason and so recycling of WAL segments couldn't be performed. Was
there anything in the postmaster log about write failures?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-12-09 16:34:41 Re: BUG #2103: System column oid is not unique
Previous Message Tom Lane 2005-12-09 16:28:22 Re: BUG #2100: CREATE TABLE AS - may not supply table specification