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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
