Re: When do vacuumed pages/tuples become available for reuse?

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: When do vacuumed pages/tuples become available for reuse?
Дата
Msg-id CAHOFxGq5oNrJPGbGfAFC3iKkOLk=06_CeAMTyfE_ywj8BA=yaA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: When do vacuumed pages/tuples become available for reuse?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: When do vacuumed pages/tuples become available for reuse?
Список pgsql-general
Дерево обсуждения
> 2019-04-11 19:39:44.450844500   tuples: 19150 removed, 2725811 remain, 465 are dead but not yet removable

What Jeff said.  This vacuum spent a lot of time, only to remove miserly
19k tuples, but 2.7M dead tuples remained ... probably because you have
long-running transactions preventing vacuum from removing them.  Maybe
that was pg_dump.

Wouldn't "dead but not yet removable" be high if there were long running transactions holding onto old row versions?

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?