On Jan 18, 2006, at 14:17 , kishore(dot)sainath(at)gmail(dot)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
Michael Glaesemann
grzm myrealbox com