Horton
Menu

Re: reltoastidxid altenates in postgresql 9.4

Josh Kupershmidt <schmiddy@gmail.com>

View thread
From: Josh Kupershmidt <schmiddy@gmail.com>
To: "Yelai, Ramkumar IN BLR STS" <ramkumar.yelai@siemens.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2015-03-10T20:50:50Z
Lists: pgsql-general 
On Thu, Mar 5, 2015 at 2:02 AM, Yelai, Ramkumar IN BLR STS
<ramkumar.yelai@siemens.com> wrote:
> Hi All,
>
> I am using the following code to know how much disk space could be saved
> after deleting certain tables (as a parameter to this function )
>
> CREATE OR REPLACE FUNCTION Get_Tables_Recovery_Size(  IN tableNames text[] )

Why not just use the built-in pg_total_relation_size?

Josh