On Apr 20, 2009, at 7:35 PM, Alvaro Herrera wrote:
> Jan Otto wrote:
>
>> If you have big toast tables you get wrong results with the query
>> suggested
>> at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the
>> toasted
>> values not into account.
>
>
>> Now a fixed query which gets the sizes of the related pg_toast_oid
>> and
>> pg_toast_oid_index too:
>
> Note that there is also the pg_total_relation_size function which will
> report the total table size, including toast table and indexes.
Ahhh, it was a long day... sometimes i think too complicated ;-)
regards, jan