Re: Performace Optimization for Dummies

[Markus Schaber <schabi(at)logix-tt(dot)com>]

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