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? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin