Re: Analyse without locking?

Richard Neill wrote:
> Or am I barking up the wrong tree entirely?
If you haven't already tuned checkpoint behavior, it's more likely
that's causing a dropout than autovacuum.  See the checkpoint_segments
section of http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
for an intro.

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com