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 <vgopal@abaca.com>)
Ответы Re: vacuum in Postgresql 8.0.x slowing down the database
Список 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
Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Vinubalaji Gopal
Дата:
Сообщение: vacuum in Postgresql 8.0.x slowing down the database
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: how can a couple of expensive queries drag my system down?