Re: Asynchronous commit documentation gap - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Asynchronous commit documentation gap
Date
Msg-id 1194167127.4258.27.camel@ebony.site
Whole thread Raw
In response to Asynchronous commit documentation gap  (Florian Weimer <fweimer@bfk.de>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: "bad key in cancel request"
Next
From: Simon Riggs
Date:
Subject: Re: xlogdump