Re: Is it possible to change the wal file size? - Mailing list pgsql-general

From u15074
Subject Re: Is it possible to change the wal file size?
Date
Msg-id 1056702619.3efc009b7a6ce@webmail.hs-harz.de
Whole thread Raw
In response to Re: Is it possible to change the wal file size?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Large Object table data file does not have expected size
Next
From: Benjamin Jury
Date:
Subject: Re: adding fields to a table