On 4/11/19 12:24 PM, Tom Lane wrote:
Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> 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.
Because "465 are dead but not yet removable" are the dead tuples that remain
instead of 2.7M?
Maybe we should adjust the wording to make that
clearer?
regards, tom lane
--
Angular momentum makes the world go 'round.
