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.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to