diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-03-07 10:42:49 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-03-07 10:43:41 +0200 |
| commit | faba108fe4f2491ebc2b7faf4343f952125cc661 (patch) | |
| tree | 393a6345bec618e5f25a1c0bb55ff933b5d87cd5 /doc/src | |
| parent | 97e3dacd84f185bff86485f54c665621222c576b (diff) | |
| download | postgresql-faba108fe4f2491ebc2b7faf4343f952125cc661.tar.gz postgresql-faba108fe4f2491ebc2b7faf4343f952125cc661.zip | |
Document the DEFERRABLE option in SET TRANSACTION command.
Kevin Grittner
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set_transaction.sgml | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index 2c57f45511b..f864bbf6a61 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -135,6 +135,17 @@ SET SESSION CHARACTERISTICS AS TRANSACTION <replaceable class="parameter">transa among those listed. This is a high-level notion of read-only that does not prevent all writes to disk. </para> + + <para> + The <literal>DEFERRABLE</literal> transaction property has no effect + unless the transaction is also <literal>SERIALIZABLE</literal> and + <literal>READ ONLY</literal>. When all of these properties are set on a + transaction, the transaction may block when first acquiring its snapshot, + after which it is able to run without the normal overhead of a + <literal>SERIALIZABLE</literal> transaction and without any risk of + contributing to or being cancelled by a serialization failure. This mode + is well suited for long-running reports or backups. + </para> </refsect1> <refsect1> |