Re: configure option for XLOG_BLCKSZ - Mailing list pgsql-patches

From Tom Lane
Subject Re: configure option for XLOG_BLCKSZ
Date
Msg-id 9728.1209834875@sss.pgh.pa.us
Whole thread Raw
In response to Re: configure option for XLOG_BLCKSZ  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: configure option for XLOG_BLCKSZ  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
List pgsql-patches
Simon Riggs <simon@2ndquadrant.com> 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 shipping.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Exposing keywords to clients
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Sigh ...