docs: mention autovacuum when ANALYZE is recommended
Hi,
Bruce asked me to look for places in the docs that mention that an
ANALYZE is recommended, to mention the possibility that autovacuum takes
care. This patch does that.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Attachments:
autoanalyze-doc.patchtext/x-diff; charset=us-asciiDownload+21-21
Alvaro Herrera <alvherre@commandprompt.com> writes:
Bruce asked me to look for places in the docs that mention that an
ANALYZE is recommended, to mention the possibility that autovacuum takes
care. This patch does that.
I think you found the right places to touch, but is "let the autovacuum
daemon do it" sufficient? It seems like that needs some qualifiers
about whether autovacuum is enabled, how long you should expect to wait
for the stats to get updated, etc. It's probably not a good idea to
duplicate all that in each place, but maybe a link to the main
documentation about autovacuum is reasonable in each place.
regards, tom lane
Tom Lane wrote:
Alvaro Herrera <alvherre@commandprompt.com> writes:
Bruce asked me to look for places in the docs that mention that an
ANALYZE is recommended, to mention the possibility that autovacuum takes
care. This patch does that.I think you found the right places to touch, but is "let the autovacuum
daemon do it" sufficient? It seems like that needs some qualifiers
about whether autovacuum is enabled, how long you should expect to wait
for the stats to get updated, etc. It's probably not a good idea to
duplicate all that in each place, but maybe a link to the main
documentation about autovacuum is reasonable in each place.
Sorry this fell through the cracks. How does this look? My idea would
be to backpatch it to 8.3 and 8.4.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Attachments:
autoanalyze-doc-2.patchtext/x-diff; charset=us-asciiDownload+31-31
Alvaro Herrera wrote:
Tom Lane wrote:
Alvaro Herrera <alvherre@commandprompt.com> writes:
Bruce asked me to look for places in the docs that mention that an
ANALYZE is recommended, to mention the possibility that autovacuum takes
care. This patch does that.I think you found the right places to touch, but is "let the autovacuum
daemon do it" sufficient? It seems like that needs some qualifiers
about whether autovacuum is enabled, how long you should expect to wait
for the stats to get updated, etc. It's probably not a good idea to
duplicate all that in each place, but maybe a link to the main
documentation about autovacuum is reasonable in each place.Sorry this fell through the cracks. How does this look? My idea would
be to backpatch it to 8.3 and 8.4.
Committed, but backpatched to 8.4 only.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support