Re: a fast bloat measurement tool

From: Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: a fast bloat measurement tool
Date: 2014-04-03 04:33:20
Message-ID: 20140403043320.GB20877@toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 2014-04-02 20:10:54 -0400, robertmhaas(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2014-04-03 04:48:12 Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Previous Message Tom Lane 2014-04-03 04:17:27 Re: It seems no Windows buildfarm members are running find_typedefs