Re: a fast bloat measurement tool - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: a fast bloat measurement tool
Date
Msg-id 20140403043320.GB20877@toroid.org
Whole thread Raw
In response to Re: a fast bloat measurement tool (was Re: Measuring relation free space)  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
At 2014-04-02 20:10:54 -0400, robertmhaas@gmail.com wrote:
>
> I think it might underestimate free space relative to tuples because
> the free space map isn't guaranteed to be completely correct.  But I
> guess you knew that already...

Yes, and tuple_len is already a slight overestimate (because it counts
the line pointer array as live tuple space for skipped pages). But for
the speedup it provides, I believe the result is still useful.

I'll mention the potential for free-space inaccuracy in the README.

-- Abhijit



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: It seems no Windows buildfarm members are running find_typedefs
Next
From: Greg Stark
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()