Re: vacuum in Postgresql 8.0.x slowing down the database

От: Joshua D. Drake
Тема: Re: vacuum in Postgresql 8.0.x slowing down the database
Дата: ,
Msg-id: 20080326130213.3797bfe1@jd-laptop
(см: обсуждение, исходный текст)
Ответ на: vacuum in Postgresql 8.0.x slowing down the database  (Vinubalaji Gopal)
Ответы: Re: vacuum in Postgresql 8.0.x slowing down the database  (Vinubalaji Gopal)
Список: pgsql-performance

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


Вложения

В списке pgsql-performance по дате сообщения:

От: "Peter Koczan"
Дата:
Сообщение: Re: postgresql is slow with larger table even it is in RAM
От: Shane Ambler
Дата:
Сообщение: Re: how can a couple of expensive queries drag my system down?