| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Florian Weimer <fweimer(at)bfk(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Asynchronous commit documentation gap |
| Date: | 2007-11-04 09:05:27 |
| Message-ID: | 1194167127.4258.27.camel@ebony.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-11-04 21:51:38 | Re: [HACKERS] PG on NFS may be just a bad idea |
| Previous Message | Florian Weimer | 2007-11-02 10:13:11 | Asynchronous commit documentation gap |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-11-04 09:13:25 | Re: xlogdump |
| Previous Message | Gregory Stark | 2007-11-04 07:36:40 | Re: Profiling vs autovacuum |