Re: too many clog files

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: too many clog files
Дата
Msg-id 48C79A55.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: too many clog files  ("Matt Smiley" <mss@rentrak.com>)
Ответы Re: too many clog files  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
> "Matt Smiley" <mss@rentrak.com> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Effects of setting linux block device readahead size
Следующее
От: "Scott Carey"
Дата:
Сообщение: Re: Effects of setting linux block device readahead size