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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: rihad <rihad(at)mail(dot)ru>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Date: 2019-04-11 17:13:17
Message-ID: CAHOFxGq5oNrJPGbGfAFC3iKkOLk=06_CeAMTyfE_ywj8BA=yaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-04-11 17:24:44 Re: When do vacuumed pages/tuples become available for reuse?
Previous Message Alvaro Herrera 2019-04-11 16:50:33 Re: When do vacuumed pages/tuples become available for reuse?