too many clog files

Поиск
Список
Период
Сортировка
От Duan Ligong
Тема too many clog files
Дата
Msg-id 20080901191255.E398.DUANLG@nec-as.nec.com.cn
обсуждение исходный текст
Ответы Re: too many clog files  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
Hi, there.

I have encountered an issue that there are too many
clog file under the .../pg_clog/ directory. Some of them
were even produced one month ago.

My questions:
- Does Vacuum delete the old clog files?
- Can we controll the maximum number of the clog files?
- When, or in what case is  a new clog file produced?
- Is there a mechanism that the clog files are recycled?

#The version of my postgresql is 8.1

Regards
Duan



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

Предыдущее
От: Thomas Finneid
Дата:
Сообщение: Re: slow update of index during insert/copy
Следующее
От: "David West"
Дата:
Сообщение: limit clause breaks query planner?