Commit6c5ced1

committed

doc: list unlogged tables as a non-durable option

1 parent5db55c6 commit6c5ced1Copy full SHA for 6c5ced1

File tree

+13

-4

lines changed

+13

-4

lines changed

Lines changed: 13 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1572,6 +1572,15 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse;`
`1572`	`1572`	`</para>`
`1573`	`1573`	`</listitem>`
`1574`	`1574`
	`1575`	`+ <listitem>`
	`1576`	`+ <para>`
	`1577`	`+ Turn off <xref linkend="guc-synchronous-commit">; there might be no`
	`1578`	`+ need to force <acronym>WAL</acronym> writes to disk on every`
	`1579`	`+ commit. This setting does risk transaction loss (though not data`
	`1580`	`+ corruption) in case of a crash of the <emphasis>database</>.`
	`1581`	`+ </para>`
	`1582`	`+ </listitem>`
	`1583`	`+`
`1575`	`1584`	`<listitem>`
`1576`	`1585`	`<para>`
`1577`	`1586`	`Turn off <xref linkend="guc-full-page-writes">; there is no need`
`@@ -1590,12 +1599,12 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse;`
`1590`	`1599`
`1591`	`1600`	`<listitem>`
`1592`	`1601`	`<para>`
`1593`		`- Turn off <xref linkend="guc-synchronous-commit">; there might be no`
`1594`		`- need to write the <acronym>WAL</acronym> to disk on every`
`1595`		`- commit. This setting does risk transaction loss (though not data`
`1596`		`- corruption) in case of a crash of the <emphasis>database</> alone.`
	`1602`	`+ Create <link linkend="SQL-CREATETABLE-UNLOGGED">unlogged`
	`1603`	`+ tables</link> to avoid <acronym>WAL</acronym> writes, though it`
	`1604`	`+ makes the tables non-crash-safe.`
`1597`	`1605`	`</para>`
`1598`	`1606`	`</listitem>`
	`1607`	`+`
`1599`	`1608`	`</itemizedlist>`
`1600`	`1609`	`</para>`
`1601`	`1610`	`</sect1>`

Comments

(0)