>> Also, locking while it does its work.
>
> Eh?
Even if we're doing lazy vacuum, we have to lock a few pages at a time
of each table. This does result in response time delays on the current
workload, which can be quite bad if it's a highly contended table already.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com