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 Michael Glaesemann grzm myrealbox com
