diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-08-07 20:54:31 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-08-07 20:54:31 +0000 |
| commit | 05f43650fcf008a12dd92db4d1ae15c43046e62c (patch) | |
| tree | 3ab600fed618c477c2069e66cb80817a42c45a2e /doc/src/sgml/perform.sgml | |
| parent | 7798147a7642521055f48e1b27b7024c46c6b446 (diff) | |
| download | postgresql-05f43650fcf008a12dd92db4d1ae15c43046e62c.tar.gz | |
Document that autovacuum may run ANALYZE
Diffstat (limited to 'doc/src/sgml/perform.sgml')
| -rw-r--r-- | doc/src/sgml/perform.sgml | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 1a631d3d91..d1ae3efb33 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/perform.sgml,v 1.71 2009/06/17 21:58:49 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/perform.sgml,v 1.72 2009/08/07 20:54:31 alvherre Exp $ --> <chapter id="performance-tips"> <title>Performance Tips</title> @@ -974,7 +974,10 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; table. With no statistics or obsolete statistics, the planner might make poor decisions during query planning, leading to poor performance on any tables with inaccurate or nonexistent - statistics. + statistics. Note that if the autovacuum daemon is enabled, it might + run <command>ANALYZE</command> automatically; see + <xref linkend="vacuum-for-statistics" endterm="vacuum-for-statistics-title"> + and <xref linkend="autovacuum" endterm="autovacuum-title"> for more information. </para> </sect2> @@ -1054,7 +1057,9 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; while loading the data, but don't bother increasing <varname>maintenance_work_mem</varname>; rather, you'd do that while manually recreating indexes and foreign keys afterwards. - And don't forget to <command>ANALYZE</> when you're done. + And don't forget to <command>ANALYZE</> when you're done; see + <xref linkend="vacuum-for-statistics" endterm="vacuum-for-statistics-title"> + and <xref linkend="autovacuum" endterm="autovacuum-title"> for more information. </para> </sect2> </sect1> |