| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | rama <rsomaraju(at)masergy(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How do you change the size of the WAL files? |
| Date: | 2012-01-10 00:44:58 |
| Message-ID: | CAOR=d=1TFS-WmTMJSS370XYdthB1t6Sw2vvFxWx6UNSA-Ff6iw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 9, 2012 at 4:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> rama <rsomaraju(at)masergy(dot)com> writes:
>> Due to the small file size I see thousands of files being generated and it
>> takes for ever to list thousands of files from archive directory which
>> stores 2 days worth of files. Sizing of WAL logs should be left to the
>> choice of people using the software. Limiting to a very small random 16MB
>> size isn't a good design.
>
> There are tradeoffs in the other direction too, but if you feel you must
> have a different value, see configure's --with-wal-segsize option. Note
> that you cannot change this without re-initdb.
Is there a limit to the max size?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-01-10 01:06:43 | Re: How do you change the size of the WAL files? |
| Previous Message | Scott Marlowe | 2012-01-10 00:17:33 | Re: queries timeout during backup postgres database |