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