Re: What is VACUUM waiting for? - Mailing list pgsql-admin

From Matthew T. O'Connor
Subject Re: What is VACUUM waiting for?
Date
Msg-id 4943C70C.9070307@zeut.net
Whole thread Raw
In response to What is VACUUM waiting for?  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Responses Re: What is VACUUM waiting for?  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
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?


pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: What is VACUUM waiting for?
Next
From: paulo matadr
Date:
Subject: Urgente error in restore prod