Re: Autovacuum and OldestXmin

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Autovacuum and OldestXmin
Дата
Msg-id 20081103190427.GU4509@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Autovacuum and OldestXmin  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Alvaro Herrera wrote:
> Simon Riggs wrote:

> > [Also there is a comment saying "this is a bug" in autovacuum.c
> > Are we thinking to go production with that phrase in the code?]
> 
> Yeah, well, it's only a comment ;-)  The problem is that a worker can
> decide that a table needs to be vacuumed, if another worker has finished
> vacuuming it in the last 500 ms.  I proposed a mechanism to close the
> hole but it was too much of a hassle.

I just committed a patch that should fix this problem.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: pg_typeof() patch review
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgstat delay in autovacuum