Horton

Re: [PATCH] Unremovable tuple monitoring

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Yeb Havinga <yebhavinga@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, Royce Ausburn <royce.ml@inomial.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Kevin Grittner <kevin.grittner@wicourts.gov>
Date: 2011-11-16T14:34:09Z
Lists: pgsql-hackers 
Robert Haas <robertmhaas@gmail.com> writes:
> Not sure about the log line, but allowing pgstattuple to distinguish
> between recently-dead and quite-thoroughly-dead seems useful.

The dividing line is enormously unstable though.  pgstattuple's idea of
RecentGlobalXmin could even be significantly different from that of a
concurrently running VACUUM.  I can see the point of having VACUUM log
what it did, but opinions from the peanut gallery aren't worth much.

			regards, tom lane