"Henrik Steffen" <steffen@city-map.de> writes:
> This is what it says in the manual and what I have been doing until today:
>
> "You should run VACUUM periodically to clean out expired rows. For tables that are heavily modified, it is useful to
runVACUUM
> every night in an automated manner. For tables with few modifications, VACUUM should be run less frequently. The
commandexclusively
> locks the table while processing. "
The "exclusive lock" part is no longer true as of 7.2.X--it is now
much cheaper to run VACUUM. What version were you running again?
-Doug