Re: [PATCH] Unremovable tuple monitoring

On Wed, Nov 16, 2011 at 3:31 AM, Yeb Havinga <yebhavinga@gmail.com> wrote:
> Apparently pg_stat* counts the recently_dead tuple under n_live_tup, else 2
> is a wrong number, where pgstattuple counts recently_dead under
> dead_tuple_count. This could be a source of confusion. If there is any
> serious work considered here, IMHO at least the numbers of the two different
> sources of tuple counters should match in terminology and actual values.

+1.

> Maybe also if pgstattuple were to include the distinction unremovable dead
> tuples vs dead tuples, a log line by vacuum encountering unremovable dead
> tuples could refer to pgstattuple for statistics.

Not sure about the log line, but allowing pgstattuple to distinguish
between recently-dead and quite-thoroughly-dead seems useful.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company