Re: vacuum in Postgresql 8.0.x slowing down the database - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: vacuum in Postgresql 8.0.x slowing down the database
Date
Msg-id 20080326130213.3797bfe1@jd-laptop
Whole thread Raw
In response to vacuum in Postgresql 8.0.x slowing down the database  (Vinubalaji Gopal <vgopal@abaca.com>)
Responses Re: vacuum in Postgresql 8.0.x slowing down the database  (Vinubalaji Gopal <vgopal@abaca.com>)
List pgsql-performance
On Wed, 26 Mar 2008 12:49:56 -0800
Vinubalaji Gopal <vgopal@abaca.com> 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

pgsql-performance by date:

Previous
From: Vinubalaji Gopal
Date:
Subject: vacuum in Postgresql 8.0.x slowing down the database
Next
From: Alan Hodgson
Date:
Subject: Re: how can a couple of expensive queries drag my system down?