Re: Reducing excess files in pg_xlog

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reducing excess files in pg_xlog
Дата
Msg-id 22416.1269276464@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reducing excess files in pg_xlog  (Thom Brown <thombrown@gmail.com>)
Список pgsql-general
Thom Brown <thombrown@gmail.com> writes:
> I've just forced a new WAL file by writing lots of stuff to a table, then
> deleting it.  It appears to be recyling the filenames now.  The latest files
> end in DD and DE, and the earliest is DF.  Presumably these will slowly get
> eaten up until it's just down to the 3 files I've configured it for?

The expected steady state is something like 2*checkpoint_segments+1
files.  See docs.

            regards, tom lane

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Reducing excess files in pg_xlog
Следующее
От: Chris Barnes
Дата:
Сообщение: Create a function that updates the record with and timestamps