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.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.