On Thu, Mar 25, 2010 at 11:01 AM, Tadipathri Raghu <traghu.dba@xxxxxxxxx> wrote: > Hi All, > > Can anybody clarify on this, why wal_buffer is 64kb and what is advantages > and disadvantages in increasing or decreasing the wal_buffer. > is 64kb just because by default we have low values in almost everything :) and the advantages is that if your average transaction is more than 64kb large all wal data will be in memory until commit, actually i thing it should be large enough to accomodate more than one transaction but i'm not sure about that one... i usually use 1Mb for OLTP systems -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
