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
sync_commit.v23.tar.bz2
Description: application/bzip-compressed-tar
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster