next up previous contents index
Next: EXPLAIN Up: Performance Previous: VACUUM

  
VACUUM ANALYZE

 The VACUUM ANALYZE command resembles VACUUM, but also collects statistics about each column's proportion of duplicate values and the maximum and minimum values. POSTGRESQL uses this information when deciding how to efficiently execute complex queries. You should run VACUUM ANALYZE when a table is initially loaded and when a table's data changes dramatically.

The VACUUM manual page shows all of the VACUUM options.  


Bruce Momjian
2001-05-09