"Dan Armbrust" <[EMAIL PROTECTED]> writes:
> Why did those particular tables and indexes take _so_ long to vacuum?
> Perhaps we have a disk level IO problem on this system?
FWIW, I agree with Scott that you seem to have an overstressed I/O
system. It's hard to tell why from here.
> Can someone tell me what 'CPU 44.46s/11.82u sec' means? I have a
> guess, but I'm not sure.
That's the vacuum process's system and user CPU-time consumption as
reported by getrusage(2). It's evidently only a minor component of the
elapsed runtime, though, so you need to be looking at I/O costs.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
