Horton
Menu

Re: Table size does not include toast size

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

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>, Bernd Helmle <mailings@oopsware.de>, Rafael Martinez <r.m.guerrero@usit.uio.no>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-12-22T14:55:17Z
Lists: pgsql-hackers 
=?ISO-8859-1?Q?C=E9dric_Villemain?= <cedric.villemain.debian@gmail.com> writes:
> 2009/12/21 Tom Lane <tgl@sss.pgh.pa.us>:
>> Perhaps invent pg_table_size() = base table + toast table + toast index
>> and       pg_indexes_size() = all other indexes for table
>> giving us the property pg_table_size + pg_indexes_size =
>> pg_total_relation_size

> Did you mean :
>  pg_table_size() = base table + toast table
>  pg_indexes_size() = base indexes + toast indexes
> ?

No.

			regards, tom lane