Hi, Carlo, Carlo Stonebanks wrote: > From what I can see, autovacuum is hitting the db's in question about once > every five minutes. Does this imply an ANALYZE is being done automatically > that would meet the requirements we are talking about here? Is there any > benefit ot explicitly performing an ANALYZE? Autovacuum looks at the modification statistics (they count how much modifications happened on the table), and decides whether it's time to VACUUM (reclaim empty space) and ANALYZE (update column value distributions) the table. The exact thresholds for Autovacuum to kick in are configurable, see the docs. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
