Re: Query performance inconsistant.

[Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>]

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