Skip site navigation (1) Skip section navigation (2)

Re: docs: mention autovacuum when ANALYZE is recommended

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: docs: mention autovacuum when ANALYZE is recommended
Date: 2009-04-28 21:58:51
Message-ID: 18865.1240955931@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-04-28 22:21:04
Subject: Re: Building Postgresql under Windows question
Previous:From: Andrew DunstanDate: 2009-04-28 21:58:39
Subject: Re: Building Postgresql under Windows question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group