Re: a fast bloat measurement tool (was Re: Measuring relation free space) - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: a fast bloat measurement tool (was Re: Measuring relation free space)
Date
Msg-id 20150424023410.GA9726@toroid.org
Whole thread Raw
In response to Re: a fast bloat measurement tool (was Re: Measuring relation free space)  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: a fast bloat measurement tool (was Re: Measuring relation free space)
List pgsql-hackers
At 2015-04-24 07:22:27 +0530, amit.kapila16@gmail.com wrote:
>
> Few minor issues:
> 1.
> warning on windows
> 
> \pgstatbloat.c(193): warning C4715: 'pgstatbloat' : not all control paths
> return a value

This is because the function ends with an ereport(ERROR, …). What would
you suggest here? Just stick a PG_RETURN_NULL() at the end?

> 2.
> Failed to install pgstattuple--1.3.sql
> 
> You have to name sql file as pgstattuple--1.3.sql rather
> than pgstattuple--1.2.sql

How are you applying the patch? It already contains this:
   diff --git a/contrib/pgstattuple/pgstattuple--1.2.sql b/contrib/pgstattuple/pgstattuple--1.3.sql   similarity index
73%  rename from contrib/pgstattuple/pgstattuple--1.2.sql   rename to contrib/pgstattuple/pgstattuple--1.3.sql   index
e5fa2f5..93593ee100644   --- a/contrib/pgstattuple/pgstattuple--1.2.sql   +++
b/contrib/pgstattuple/pgstattuple--1.3.sql

So it should do the right thing with git apply.

-- Abhijit



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Supporting TAP tests with MSVC and Windows
Next
From: Stephen Frost
Date:
Subject: Re: Fwd: [GENERAL] 4B row limit for CLOB tables