On Wed, 26 Mar 2008 12:49:56 -0800
Vinubalaji Gopal <[EMAIL PROTECTED]> wrote:

> The big table has never been reindexed and has a primary, unique key
> with btree index and one foreign key constraint.

The slowness is likely attributed to Vacuum's use of I/O. When vacuum
is running what does iostat -k 10 say?

Joshua D. Drake



-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

Attachment: signature.asc
Description: PGP signature

Reply via email to