Re: pg_clogs hanging around

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: pg_clogs hanging around
Дата
Msg-id 4D77904C020000250003B703@gw.wicourts.gov
обсуждение исходный текст
Ответ на pg_clogs hanging around  (Scott Whitney <scott@journyx.com>)
Список pgsql-admin
Scott Whitney <scott@journyx.com> wrote:

> my pg_clog directory contains files going back to Jul 13 of 2010.
>
> Every Saturday, I run:
>
> "vacuumdb -a -v -F"
>
>
> I _thought_ that was supposed to clear those out. Am I wrong?

SELECT datname, datfrozenxid FROM pg_database;

to see which database is causing them to be retained.

-Kevin

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

Предыдущее
От: Scott Whitney
Дата:
Сообщение: pg_clogs hanging around
Следующее
От: Dinesh Bhandary
Дата:
Сообщение: hiding metadata information from a user