On Wed, Sep 10, 2008 at 8:58 AM, Kevin Grittner
>> "Matt Smiley" <mss(at)rentrak(dot)com> wrote:
>> Alvaro Herrera wrote:
>>> Move the old clog files back where they were, and run VACUUM FREEZE
>>> all your databases. That should clean up all the old pg_clog files,
>>> you're really that desperate.
>> Has anyone actually seen a CLOG file get removed under 8.2 or 8.3?
> Some of my high-volume databases don't quite go back to 0000, but this
> does seem to be a problem. I have confirmed that VACUUM FREEZE on all
> but template0 (which doesn't allow connections) does not clean them
> up. No long running transactions are present.
I have a pretty high volume server that's been online for one month
and it had somewhere around 53, going back in order to 0000, and it
was recently vacuumdb -az 'ed. Running another one. No long running
In response to
pgsql-performance by date
|Next:||From: Mark Wong||Date: 2008-09-10 17:38:30|
|Subject: Re: Effects of setting linux block device readahead size|
|Previous:||From: Dimitri Fontaine||Date: 2008-09-10 17:17:37|
|Subject: Re: Improve COPY performance for large data sets|