| Lists: | pgsql-docspgsql-hackers |
|---|
| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Asynchronous commit documentation gap |
| Date: | 2007-11-02 10:13:11 |
| Message-ID: | 82ejf9q7k8.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-hackers |
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.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| 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: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Florian Weimer <fweimer(at)bfk(dot)de> |
| Cc: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Asynchronous commit documentation gap |
| Date: | 2007-11-05 17:35:50 |
| Message-ID: | 200711051735.lA5HZoo12517@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-hackers |
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.
Nice. I made the following documentation change, attached.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| Attachment | Content-Type | Size |
|---|---|---|
| /rtmp/diff | text/x-diff | 1.1 KB |