Re: Table size does not include toast size - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table size does not include toast size
Date
Msg-id 8475.1261493717@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table size does not include toast size  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-hackers
Cédric 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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: alpha3 release schedule?
Next
From: Tom Lane
Date:
Subject: Re: Tuplestore should remember the memory context it's created in