Re: How do you change the size of the WAL files? - Mailing list pgsql-general

From runner
Subject Re: How do you change the size of the WAL files?
Date
Msg-id 8CDAE2D10CCA863-15B0-1B271@web-mmc-d05.sysops.aol.com
Whole thread Raw
In response to Re: How do you change the size of the WAL files?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: How do you change the size of the WAL files?  (Merlin Moncure <mmoncure@gmail.com>)
Re: How do you change the size of the WAL files?  (Bruce Momjian <bruce@momjian.us>)
Re: How do you change the size of the WAL files?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general

>> 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.


We are doing continuous archiving and we have thousands of these 16 Mb archive files on disk.
My boss is used to using Oracle where you can set the size of the files.
He'd rather have fewer but larger archive files.


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How do you change the size of the WAL files?
Next
From: Merlin Moncure
Date:
Subject: Re: How do you change the size of the WAL files?