Re: some longer, larger pgbench tests with various performance-related patches - Mailing list pgsql-hackers

From Robert Haas
Subject Re: some longer, larger pgbench tests with various performance-related patches
Date
Msg-id CA+TgmobL32HgVNs98dzkve0FaqF3Jr4Y7RinRjv0CyJJJZkf2g@mail.gmail.com
Whole thread Raw
In response to Re: some longer, larger pgbench tests with various performance-related patches  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: some longer, larger pgbench tests with various performance-related patches
List pgsql-hackers
On Tue, Jan 24, 2012 at 4:28 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> I think we should be working to commit XLogInsert and then Group
> Commit, then come back to the discussion.

I definitely agree that those two have way more promise than anything
else on the table.  However, now that I understand how badly we're
getting screwed by checkpoints, I'm curious to do some more
investigation of what's going on there.  I can't help thinking that in
these particular cases the full page writes may be a bigger issue than
the checkpoint itself.  If that turns out to be the case it's not
likely to be something we're able to address for 9.2, but I'd like to
at least characterize it.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Jim Mlodgenski
Date:
Subject: Re: Client Messages
Next
From: Robert Haas
Date:
Subject: Re: [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.