Re: Async Commit, v21 (now: v22) - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Async Commit, v21 (now: v22)
Date
Msg-id 1184845484.5653.69.camel@ebony.site
Whole thread Raw
In response to Re: Async Commit, v21 (now: v22)  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: Async Commit, v21 (now: v22)
Re: Async Commit, v21 (now: v22)
Re: Async Commit, v21 (now: v22)
List 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

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: execl() sentinel
Next
From: Magnus Hagander
Date:
Subject: Re: SSPI authentication - patch