Re: What is VACUUM waiting for?

Michael Monnerie wrote:
> Dear list, this is postgres 8.1, and I run a dbmail mailserver where we deleted most e-mails.
> I then did a VACUUM (see below), and just before the "dbmail_messages" truncated rows
> there was a very long time where obviously nothing happened. No CPU usage (<8%) and
> no disk I/O (usage <5%). You can see this from the details:
> DETAIL:  CPU 0.11s/0.23u sec elapsed 294.24 sec.
> I would have expected I/Os at least. How does VACUUM work at all?
>

Do you have any vacuum delay setting turned on?  Perhaps they are too high?