Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: vacuum in Postgresql 8.0.x slowing down the database
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Vinubalaji Gopal <vgopal(at)abaca(dot)com>
- Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: vacuum in Postgresql 8.0.x slowing down the database
- Date: Wed, 26 Mar 2008 13:02:13 -0700
On Wed, 26 Mar 2008 12:49:56 -0800 Vinubalaji Gopal <vgopal(at)abaca(dot)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:
signature.asc
Description: PGP signature
- Follow-Ups:
- Re: vacuum in Postgresql 8.0.x slowing down the database
- From: Vinubalaji Gopal
- Re: vacuum in Postgresql 8.0.x slowing down the database
- References:
- vacuum in Postgresql 8.0.x slowing down the database
- From: Vinubalaji Gopal
- vacuum in Postgresql 8.0.x slowing down the database
- Prev by Date: vacuum in Postgresql 8.0.x slowing down the database
- Next by Date: Re: how can a couple of expensive queries drag my system down?
- Previous by thread: vacuum in Postgresql 8.0.x slowing down the database
- Next by thread: Re: vacuum in Postgresql 8.0.x slowing down the database
- Indexes: