Commitfaba108

committed

Document the DEFERRABLE option in SET TRANSACTION command.

Kevin Grittner

1 parent97e3dac commitfaba108Copy full SHA for faba108

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -135,6 +135,17 @@ SET SESSION CHARACTERISTICS AS TRANSACTION <replaceable class="parameter">transa`
`135`	`135`	`among those listed. This is a high-level notion of read-only that`
`136`	`136`	`does not prevent all writes to disk.`
`137`	`137`	`</para>`
	`138`	`+`
	`139`	`+ <para>`
	`140`	`+ The <literal>DEFERRABLE</literal> transaction property has no effect`
	`141`	`+ unless the transaction is also <literal>SERIALIZABLE</literal> and`
	`142`	`+ <literal>READ ONLY</literal>. When all of these properties are set on a`
	`143`	`+ transaction, the transaction may block when first acquiring its snapshot,`
	`144`	`+ after which it is able to run without the normal overhead of a`
	`145`	`+ <literal>SERIALIZABLE</literal> transaction and without any risk of`
	`146`	`+ contributing to or being cancelled by a serialization failure. This mode`
	`147`	`+ is well suited for long-running reports or backups.`
	`148`	`+ </para>`
`138`	`149`	`</refsect1>`
`139`	`150`
`140`	`151`	`<refsect1>`

Comments

(0)