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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: When do vacuumed pages/tuples become available for reuse?
Дата
Msg-id 21385.1555003484@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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?
Re: When do vacuumed pages/tuples become available for reuse?
Список pgsql-general
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> On 2019-Apr-11, rihad wrote:
>> 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.

I think you misread it --- I'm pretty sure "N remain" is referring
to live tuples.  Maybe we should adjust the wording to make that
clearer?

            regards, tom lane



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

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