Re: How do you change the size of the WAL files?

From: runner <runner(at)winning(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How do you change the size of the WAL files?
Date: 2011-03-11 17:58:30
Message-ID: 8CDAE2D10CCA863-15B0-1B271@web-mmc-d05.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-03-11 18:07:21 Re: How do you change the size of the WAL files?
Previous Message Bruce Momjian 2011-03-11 17:51:40 Re: How do you change the size of the WAL files?