Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitb4fd1e2

Browse files
committed
Document that autovacuum cannot vacuum or analyze temporary tables.
1 parentb6c586a commitb4fd1e2

File tree

2 files changed

+17
-2
lines changed

2 files changed

+17
-2
lines changed

‎doc/src/sgml/maintenance.sgml

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff 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 $ -->
22

33
<chapter id="maintenance">
44
<title>Routine Database Maintenance Tasks</title>
@@ -642,6 +642,12 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu
642642
since the last <command>ANALYZE</command>.
643643
</para>
644644

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+
645651
<para>
646652
The default thresholds and scale factors are taken from
647653
<filename>postgresql.conf</filename>, but it is possible to override them

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 10 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
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 $
33
PostgreSQL documentation
44
-->
55

@@ -144,6 +144,15 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR
144144
table are automatically temporary as well.
145145
</para>
146146

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+
147156
<para>
148157
Optionally, <literal>GLOBAL</literal> or <literal>LOCAL</literal>
149158
can be written before <literal>TEMPORARY</> or <literal>TEMP</>.

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp