Re: How do you change the size of the WAL files?

Поиск
Список
Период
Сортировка
От runner
Тема Re: How do you change the size of the WAL files?
Дата
Msg-id 8CDAE2D10CCA863-15B0-1B271@web-mmc-d05.sysops.aol.com
обсуждение исходный текст
Ответ на Re: How do you change the size of the WAL files?  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: How do you change the size of the WAL files?  (Merlin Moncure <mmoncure@gmail.com>)
Re: How do you change the size of the WAL files?  (Bruce Momjian <bruce@momjian.us>)
Re: How do you change the size of the WAL files?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general

>> Our WAL files are 16 Mb in size each. I cannot find where you

>>  configure them to make them larger.  16 Mb is too small for our
>> instalation. If necessary, I can rebuild the entire cluster. Our
>> DBA initialized a new cluster and specified a larger WAL size but it
>> stayed at 16 Mb. Any info on this?

> Why is 16MB too small? Most people increase checkpoint_segments for
> larger installs and it works fine.


We are doing continuous archiving and we have thousands of these 16 Mb archive files on disk.
My boss is used to using Oracle where you can set the size of the files.
He'd rather have fewer but larger archive files.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: How do you change the size of the WAL files?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: How do you change the size of the WAL files?