Re: checkpoint patches - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: checkpoint patches
Date
Msg-id 20120323004421.GF3938@tamriel.snowman.net
Whole thread Raw
In response to Re: checkpoint patches  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: checkpoint patches  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Thu, Mar 22, 2012 at 3:45 PM, Stephen Frost <sfrost@snowman.net> wrote:
> > Well, those numbers just aren't that exciting. :/
>
> Agreed.  There's clearly an effect, but on this test it's not very big.

Ok, perhaps that was because of how you were analyzing it using the 90th
percetile..?

> See attached.  It looks a whole lot like the tps graph, if you look at
> the tps graph upside with your 1/x glasses on.

Well, what I'm looking at with this graph are the spikes on master up to
near 100ms latency (as averaged across 10 seconds) while
checkpoint-sync-pause-v1 stays down closer to 60 and never above 70ms.
That makes this patch look much more interesting, in my view..

I'm assuming there's some anomaly or inconsistincy with the last few
seconds, where the latency drops for master and spikes with the patch.
If there isn't, then it'd be good to have a longer run to figure out if
there really is an issue with the checkpoint patch still having major
spikes.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Daniel Farina
Date:
Subject: Standbys, txid_current_snapshot, wraparound
Next
From: Fujii Masao
Date:
Subject: Reporting WAL file containing checkpoint's REDO record in pg_controldata's result