Alvaro Herrera <[EMAIL PROTECTED]> writes:
> The other patch was ITAGAKI Takahiro's patch to fix n_dead_tuples in
> pgstats after VACUUM when there is concurrent update activity.  This
> patch is still on hold largely because the above patch would cause it to
> be a bit obsolete.

I objected (and still object) to this patch because it allows
n_dead_tuples to drift arbitrarily far away from reality --- a series of
vacuums will incrementally update it using probably-inaccurate deltas,
and there's nothing to ensure that the result converges rather than
diverging.  In the real world it will result in n_dead_tuples becoming
less accurate, not more so.

There was some discussion about better ways to do it, IIRC, but no new
patch has been submitted.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to