Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong

"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> On Mon, Mar 31, 2008 at 9:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It looks like there's no trivial way to get ANALYZE to do things that
>> way, though.  heap_release_fetch() doesn't distinguish a DEAD line
>> pointer from an unused or redirected one.  But in the current
>> implementation of ANALYZE there's really no benefit to using
>> heap_release_fetch anyway --- it always examines all line pointers
>> on each selected page, so we might as well rewrite it to use a simple
>> loop more like vacuum uses.

> I agree. I would write a patch on these lines, unless you are already on to it.

Please do --- I have a lot of other stuff on my plate.

            regards, tom lane