Re: Query performance inconsistant.

Jeff Davis wrote:
> http://www.postgresql.org/docs/8.1/static/mvcc.html
>
> In the "Explicit Locking" section it details the locks acquired by
> UPDATE, etc.
>
>From what you described, I would not expect many locking problems. Are
> there any other types of queries you run that may cause a lock? Do you
> run periodic "VACUUM FULL" or something? "VACUUM FULL" causes a full
> table lock, and is usually not necessary. If so, try running just
> "VACUUM" without "FULL".
>
> Regards,
>     Jeff Davis
>

Jeff,

I have "autovacuum = on" in the config file with a pretty frequent
autovacuum_naptime, but I'm unsure if that does a vacuum or vacuum full.

schu