Postgres Pro
Downloads
Home   >   mailing lists

Re: reltoastidxid altenates in postgresql 9.4 - Mailing list pgsql-general

From Josh Kupershmidt
Subject Re: reltoastidxid altenates in postgresql 9.4
Date
Msg-id CAK3UJRH4Z+JBLSB6cwyjoqxd=emWFbQZbp0jy5VyJkWBSr=X_w@mail.gmail.com
Whole thread Raw
In response to reltoastidxid altenates in postgresql 9.4  ("Yelai, Ramkumar IN BLR STS" <ramkumar.yelai@siemens.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to read refcursor column's using string column name?
Next
From: "Deole, Pushkar (Pushkar)"
Date:
Subject: Asynchronous replication in postgresql