Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group