--On 21. Dezember 2009 10:01:37 -0500 Tom Lane <t...@sss.pgh.pa.us> wrote:

It's not supposed to.  Use pg_total_relation_size if you want a number
that includes index and toast space.

I've created a C-Function a while ago that extracts the TOAST size for a given relation. This gave me the opportunity to do a pg_relation_size(oid) + pg_relation_toast_size(oid) for a given table oid to calculate on disk data size required by a table. Maybe we should include such a function in core?

--
Thanks

        Bernd

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to