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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
