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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How do you change the size of the WAL files?
Дата
Msg-id 201103111751.p2BHpeD27641@momjian.us
обсуждение исходный текст
Ответ на How do you change the size of the WAL files?  (runner <runner@winning.com>)
Ответы Re: How do you change the size of the WAL files?  (runner <runner@winning.com>)
Re: How do you change the size of the WAL files?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
runner wrote:
>
>
>
>  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.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

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

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