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

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