Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 785359F96AD for ; Sun, 4 Nov 2007 05:05:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70010-02 for ; Sun, 4 Nov 2007 05:05:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail128171.authsmtp.com (outmail128171.authsmtp.com [62.13.128.171]) by postgresql.org (Postfix) with ESMTP id 0A4679F965E for ; Sun, 4 Nov 2007 05:05:27 -0400 (AST) Received: from outmail128179.authsmtp.co.uk (outmail128179.authsmtp.co.uk [62.13.128.179]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lA495PrO080187; Sun, 4 Nov 2007 09:05:25 GMT Received: from [192.168.0.3] (85-211-24-246.dyn.gotadsl.co.uk [85.211.24.246]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lA495OVm010519; Sun, 4 Nov 2007 09:05:24 GMT Subject: Re: Asynchronous commit documentation gap From: Simon Riggs To: Florian Weimer Cc: pgsql-hackers@postgresql.org In-Reply-To: <82ejf9q7k8.fsf@mid.bfk.de> References: <82ejf9q7k8.fsf@mid.bfk.de> Content-Type: text/plain Date: Sun, 04 Nov 2007 09:05:27 +0000 Message-Id: <1194167127.4258.27.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 14273778-8ab5-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAFbY1ZH HGQLW1NEUFR7WWZ/ aQ4fZQBDYEtPQQdu TkpNRE1QERpoT0Bw AhcbLX8vdwRGfX95 K05hXT5aWEZ9dkF6 SlNcRD8DeGZhPDMC AkheJh5UcAJLdhoR aVd4ByJDAzANdhEY NiQQEgoKCH12MzVT SQEXKlQVXF1DFTk5 QhEeVTkoFlAASiMv JgAnLVhUE08JWicA X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/114 X-Sequence-Number: 110039 On Fri, 2007-11-02 at 11:13 +0100, Florian Weimer wrote: > The documentation doesn't really tell how to disable synchronous > commits for a single commit. I believe the correct command is > > SET LOCAL synchronous_commit TO OFF; > > just before the COMMIT statement. Yes, in fact anywhere within the transaction will do. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com