On Mon, 20 Apr 2009, 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.
I can't recall why I wrote that to filter out things in the pg_toast namespace in the first place. I just took the easy way out here--the query has been updated to not exclude relations in that namespace anymore and I link to the TOAST docs for more details.
I consider combining all the values together, as you did in your example code and as pg_total_relation_size does, as a different type of report. Accordingly, I just updated with examples of both types, as well as something to work against pre-8.1 databases.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
