| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| sync_commit.v23.tar.bz2 | application/x-bzip-compressed-tar | 24.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-07-19 11:53:15 | Re: SSPI authentication - patch |
| Previous Message | Alvaro Herrera | 2007-07-19 03:29:34 | Re: execl() sentinel |