Jeff <threshar(at)torgo(dot)978(dot)org> writes:
> Given some recent posts / irc issues with dead tuple bloat..
> And given that a lot of these people have at least been smart enough to
> explain analyze would it be A. possible B. useful C. None of the above
> to have various "scan" nodes of explain analyze also report how many
> invisible / dead tuples they had to disqualify (Just to clarify, they
> matched the search criteria, but were invisible due to MVCC rules).
I think this would not help a whole lot because (particularly on
indexscans) you won't get a very accurate picture of the true extent
of bloat. The contrib/pgstattuple utility is more useful for measuring
that sort of thing.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2005-02-25 16:20:05|
|Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout|
|Previous:||From: Stephan Szabo||Date: 2005-02-25 14:56:10|
|Subject: Re: IS NULL vs IS NOT NULL|