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

runner wrote:
>
> >> 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.

There is no option to do that, but there is pg_lesslog which shrinks
them, though I realize you want fewer, larger ones. This is a rare
request.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +