Re: [HACKERS] increasing the default WAL segment size - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] increasing the default WAL segment size
Date
Msg-id CANP8+jL+JCF++-Lt6Zui7GAFB=TOY5_XhUzc3i-inabP_sR2rQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 4 January 2017 at 13:57, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Jan 4, 2017 at 3:05 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Strange response. Nothing has been assumed. I asked for tests and you
>> provided measurements.
>
> Sure, of zero-filling a file with dd.  But I also pointed out that in
> a real PostgreSQL cluster, the change could actually *reduce* latency.

I think we are talking at cross purposes. We agree that the main
change is useful, but it causes another problem which I can't see how
you can characterize as reduced latency, based upon your own
measurements.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCH] Reload SSL certificates on SIGHUP
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] [PATCH] Reload SSL certificates on SIGHUP