| From: | Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Subject: | Re: a fast bloat measurement tool (was Re: Measuring relation free space) |
| Date: | 2015-04-03 15:37:48 |
| Message-ID: | 20150403153748.GA15210@toroid.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 2015-03-31 22:43:49 +0530, ams(at)2ndQuadrant(dot)com wrote:
>
> I'm just posting this WIP patch where I've renamed fastbloat to
> pgstatbloat as suggested by Tomas, and added in the documentation, and
> so on.
Here's the revised version that also adds the count of RECENTLY_DEAD and
INSERT/DELETE_IN_PROGRESS tuples to the call to vac_estimate_reltuples.
Tomas, I agree that the build_output_tuple function could use cleaning
up, but it's the same as the corresponding code in pgstattuple, and it
seems to me reasonable to clean both up together in a separate patch.
-- Abhijit
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Add-pgstatbloat-to-pgstattuple-20150403.patch | text/x-diff | 19.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-04-03 16:32:32 | Re: initdb -S and tablespaces |
| Previous Message | Alvaro Herrera | 2015-04-03 14:59:22 | Re: Table-level log_autovacuum_min_duration |