Skip site navigation (1) Skip section navigation (2)

Re: Async Commit, v21 (now: v22)

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>,"Peter Eisentraut" <peter_e(at)gmx(dot)net>,"Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>,"Bruce Momjian" <bruce(at)momjian(dot)us>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: Async Commit, v21 (now: v22)
Date: 2007-07-19 11:44:44
Message-ID: 1184845484.5653.69.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-patches
On Wed, 2007-07-18 at 17:16 +0100, Simon Riggs wrote:
> On Wed, 2007-07-18 at 12:04 -0400, Alvaro Herrera wrote:
> > Simon Riggs wrote:
> > 
> > > OK. Will do, thanks.
> > 
> > Make sure to remove the bogus comment about "pgstat considers our data
> > as gone" in walwriter.c as well (in the sigjmp block)
> 
> Thanks, its gone in v23.

Thanks to everyone for the various review comments.

Here's v23, including all suggested changes, plus some reworking of the
transaction APIs to reduce the footprint of the patch. 

Performance tests: pgbench -c 4 -t 10000
- pgbench standard, sync 800 tps, async 1200 tps
- single insert only, sync 3000 tps, async 9000 tps

Async performance appears to be just short of fsync=off

-- 
  Simon Riggs
  EnterpriseDB  http://www.enterprisedb.com

Attachment: sync_commit.v23.tar.bz2
Description: application/x-bzip-compressed-tar (24.1 KB)

In response to

Responses

pgsql-patches by date

Next:From: Magnus HaganderDate: 2007-07-19 11:53:15
Subject: Re: SSPI authentication - patch
Previous:From: Alvaro HerreraDate: 2007-07-19 03:29:34
Subject: Re: execl() sentinel

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group