Re: Reducing excess files in pg_xlog

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Reducing excess files in pg_xlog
Дата
Msg-id bddc86151003220736g230c54een81a7741030e690ce@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reducing excess files in pg_xlog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On 22 March 2010 14:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thom Brown <thombrown@gmail.com> writes:
> On 22 March 2010 14:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Force a checkpoint, if one hasn't happened already.

> Yeah, I've run a CHECKPOINT too, but no joy.  Still the same number of
> files.

Hm, it works for me.  What PG version is this exactly?  Are you sure
the active value of checkpoint_segments really changed?  (Use SHOW)

                       regards, tom lane

This is version 8.4.3

postgres=# show checkpoint_segments;
 checkpoint_segments
---------------------
 3
(1 row)

Not sure if it's of any relevance, but the file name sequence seems to go a bit weird.

Nov 25 19:49 0000000100000000000000FA
Nov 26 17:25 0000000100000000000000FB
Dec 16 14:50 0000000100000000000000FC
Dec 17 04:00 0000000100000000000000FD
Dec 17 15:26 0000000100000000000000FE
Dec 17 15:27 000000010000000100000000
Dec 17 15:29 000000010000000100000001
Mar 22 14:28 0000000100000000000000BF

And yes, this particular cluster has very low usage at the moment.

Thom

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