by tgl@[EMAIL PROTECTED]
(Tom Lane)
May 3, 2008 at 01:14 PM
Simon Riggs <simon@[EMAIL PROTECTED]
> writes:
> We already hit that issue and fixed it early in the 8.3 cycle. It was
> more of a problem than the checkpoint issue because it caused hard
> lock-outs while the file switches occurred. It didn't show up unless you
> looked at the very detailed transaction result data because on fast
> systems we are file switching every few seconds.
> Not seen any gains from varying the WAL file size since then...
I think the use-case for varying the WAL segment size is unrelated to
performance of the master server, but would instead be concerned with
adjusting the granularity of WAL log ****pping.
regards, tom lane
--
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
