Re: Is it possible to change the wal file size?

Поиск
Список
Период
Сортировка
От u15074
Тема Re: Is it possible to change the wal file size?
Дата
Msg-id 1056702619.3efc009b7a6ce@webmail.hs-harz.de
обсуждение исходный текст
Ответ на Re: Is it possible to change the wal file size?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
> You can not change the size but you can increase the number of WAL files
> used.
> See postgresql.conf.
>
> Setting it too high does not achieve anything though. You need to have enough
>
> disk bandwidth to make use of 200MB WAL logs.

I want write a lot of data (large objetcs) without any interruptions.
So I already increased the number of checkpoint_segments to a higher value.
But this did not help since I still get interruptions in writing data, when a
new log file is created.

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Large Object table data file does not have expected size
Следующее
От: Benjamin Jury
Дата:
Сообщение: Re: adding fields to a table