Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux