Re: Table size does not include toast size

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bernd Helmle <mailings@oopsware.de>
Cc: Greg Smith <greg@2ndquadrant.com>, Rafael Martinez <r.m.guerrero@usit.uio.no>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-01-19T05:51:42Z
Lists: pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> Since i'm not able to finish those other things in time, i wrapped up my 
> existing code for this issue and came up with the attached patch, which 
> should implement the behavior Tom proposed. These are two new functions 
> pg_table_size() and pg_indexes_size(). This patch also changes 
> pg_total_relation_size() to be a shorthand for pg_table_size() + 
> pg_indexes_size().

Applied with minor corrections.

			regards, tom lane