On Thu, 2006-01-19 at 16:46, Michael Glaesemann wrote: > On Jan 18, 2006, at 14:17 , kishore.sainath@xxxxxxxxx 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...