Large Number of Files in pg_xlog

Поиск
Список
Период
Сортировка
От Bob Lunney
Тема Large Number of Files in pg_xlog
Дата
Msg-id 793643.73193.qm@web39705.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Large Number of Files in pg_xlog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Is it possible to reduce the number of files in pg_xlog.  Currently, checkpoint_segments is set to 512, which if I
understandcorrectly, means there could be up to 1025 files in pg_xlog, 16Gb of WAL.  Right now there are 833 files.
I'vetried setting checkpoint_segments to a lower number and restarting the database, but to no avail.  Is there another
methodthat doesn't involve running a dump, initdb, and restore? 

Thanks in advance,

Bob Lunney




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: setting up a client only service
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Large Number of Files in pg_xlog