Re: Concurrent VACUUM and ANALYZE

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Concurrent VACUUM and ANALYZE
Дата
Msg-id 1216904794.3894.824.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
On Mon, 2008-07-21 at 17:50 -0400, Jonah H. Harris wrote:
> Currently, one cannot perform a concurrent VACUUM and ANALYZE.  This
> is a significant problem for tables which are not only large and have
> designated cost-delays, but which are also heavily inserted into and
> deleted from.

I suspect this is not the root problem, but one solution to it.

If the stats need such frequent updating, then the code that handles the
stats probably needs extension/improvement to avoid such sensitivities.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Uncopied parameters on CREATE TABLE LIKE
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Concurrent VACUUM and ANALYZE