On Thu, 2006-01-19 at 16:46, Michael Glaesemann wrote:
> On Jan 18, 2006, at 14:17 , kishore.sainath@gmail.com wrote:
>
> > What are the benefits of the VACUUM command in PostgreSQL?
>
> The docs have quite a bit of information on this. For a start, take a
> look at:
> http://www.postgresql.org/docs/current/interactive/
> maintenance.html#ROUTINE-VACUUMING
>
> Recently, some people of expressed that the material on autovacuum
> may be misleading. The other material should give you enough
> background, however.
>
> For some information on ANALYZE, see:
> http://www.postgresql.org/docs/current/interactive/sql-analyze.html
It's not misleading so much as just incomplete and a little hard for the
beginners to wrap their brains around...