Re: [GENERAL] reltoastidxid altenates in postgresql 9.4

2015-03-10 Thread Josh Kupershmidt
On Thu, Mar 5, 2015 at 2:02 AM, Yelai, Ramkumar IN BLR STS 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[]

[GENERAL] reltoastidxid altenates in postgresql 9.4

2015-03-10 Thread Yelai, Ramkumar IN BLR STS
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[] ) RETURNS TABLE( table_size bigint ) AS $$ DECLARE BEGIN RETURN QUE