On Wed, 26 Mar 2008 12:49:56 -0800 Vinubalaji Gopal <vgopal@xxxxxxxxx> 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
