Re: too many clog files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> "Matt Smiley" <mss@xxxxxxxxxxx> wrote: 
> Alvaro Herrera wrote:
>> Move the old clog files back where they were, and run VACUUM FREEZE
in
>> all your databases.  That should clean up all the old pg_clog files,
if
>> 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.
 
-Kevin


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux