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