Re: When do vacuumed pages/tuples become available for reuse? - Mailing list pgsql-general

From Tom Lane
Subject Re: When do vacuumed pages/tuples become available for reuse?
Date
Msg-id 21385.1555003484@sss.pgh.pa.us
Whole thread Raw
In response to Re: When do vacuumed pages/tuples become available for reuse?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: When do vacuumed pages/tuples become available for reuse?  (Ron <ronljohnsonjr@gmail.com>)
Re: When do vacuumed pages/tuples become available for reuse?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List 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 by date:

Previous
From: Michael Lewis
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Next
From: Ron
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?