| From: | u15074 <u15074(at)hs-harz(dot)de> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is it possible to change the wal file size? |
| Date: | 2003-06-27 08:30:19 |
| Message-ID: | 1056702619.3efc009b7a6ce@webmail.hs-harz.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Jury | 2003-06-27 08:53:38 | Re: adding fields to a table |
| Previous Message | Martijn van Oosterhout | 2003-06-27 08:18:36 | Re: Large Object table data file does not have expected size |