Commitb4fd1e2

committed

Document that autovacuum cannot vacuum or analyze temporary tables.

1 parentb6c586a commitb4fd1e2Copy full SHA for b4fd1e2

File tree

+17

-2

lines changed

+17

-2

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.102 2010/04/03 07:22:55 petere Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.103 2010/04/16 02:22:33 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="maintenance">`
`4`	`4`	`<title>Routine Database Maintenance Tasks</title>`
`@@ -642,6 +642,12 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu`
`642`	`642`	`since the last <command>ANALYZE</command>.`
`643`	`643`	`</para>`
`644`	`644`
	`645`	`+ <para>`
	`646`	`+ Temporary tables cannot be accessed by autovacuum. Therefore,`
	`647`	`+ appropriate vacuum and analyze operations should be performed via`
	`648`	`+ session SQL commands.`
	`649`	`+ </para>`
	`650`	`+`
`645`	`651`	`<para>`
`646`	`652`	`The default thresholds and scale factors are taken from`
`647`	`653`	`<filename>postgresql.conf</filename>, but it is possible to override them`

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.125 2010/04/03 07:23:00 petere Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.126 2010/04/16 02:22:33 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -144,6 +144,15 @@ CREATE [ [ GLOBAL \| LOCAL ] { TEMPORARY \| TEMP } ] TABLE <replaceable class="PAR`
`144`	`144`	`table are automatically temporary as well.`
`145`	`145`	`</para>`
`146`	`146`
	`147`	`+ <para>`
	`148`	`+ The <link linkend="autovacuum">autovacuum daemon</link> cannot`
	`149`	`+ access and therefore cannot vacuum or analyze temporary tables.`
	`150`	`+ For this reason, appropriate vacuum and analyze operations should be`
	`151`	`+ performed via session SQL commands. For example, if a temporary`
	`152`	`+ table is going to be used in complex queries, it is wise to run`
	`153`	`+ <command>ANALYZE</> on the temporary table after it is populated.`
	`154`	`+ </para>`
	`155`	`+`
`147`	`156`	`<para>`
`148`	`157`	`Optionally, <literal>GLOBAL</literal> or <literal>LOCAL</literal>`
`149`	`158`	`can be written before <literal>TEMPORARY</> or <literal>TEMP</>.`

Comments

(0)