Re: BUG #4059: Vacuum full not always cleaning empty tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #4059: Vacuum full not always cleaning empty tables
Дата
Msg-id 20080326130045.GE5895@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: BUG #4059: Vacuum full not always cleaning empty tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Mark Steben wrote:
> Yes, there are transactions that predate the start time of the vacuum full.
> However those transactions do not touch the table being vacuumed, they have
> nothing to do with it.  Is this the expected behavior?

Yes.  The system has no way to know that they will not examine the table
in the future, so it has to be conservative about what it removes.

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

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

Предыдущее
От:
Дата:
Сообщение: Re: BUG: PG do not use index
Следующее
От: "Mark Steben"
Дата:
Сообщение: Re: BUG #4059: Vacuum full not always cleaning empty tables