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]

 



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.

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


[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