Re: obsessive-compulsive vacuum behavior

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: obsessive-compulsive vacuum behavior
Дата
Msg-id 41B159F2-E9CD-4202-97DA-F8C92390328E@silentmedia.com
обсуждение исходный текст
Ответ на Re: obsessive-compulsive vacuum behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mar 8, 2010, at 7:16 AM, Tom Lane wrote:

> After it's done you probably ought to look into your autovacuum
> settings.  You shouldn't have gotten into a state with so many dead
> tuples in the first place, I would think, if autovac were functioning
> properly.

Yeah, it turns out our autovacuums kept getting canceled because this table gets a lot of churn. Now that we've turn
offthe cost delay, things are much happier. Thanks! 

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Not all functions in schema pg_catalog are "visible"
Следующее
От: Serguei Mokhov
Дата:
Сообщение: Re: [pgsql-ru-general] Deleting Large Objects