I've been trying to write up a "pg_total_relation_size()" replacement that just uses the system tables (sum up relpages for tables, indexes and toast tables), thereby avoiding the overhead of running stat() on thousands of filesystem tables, but I've come up against what seems to be an unsuperable problem.
The `relpages` data for the toast tables doesn't seem to get updated. Not when I run a general 'ANALYZE' call, and when I specifically call ANALYZE on the toast tables, it tells me "WARNING: skipping "pg_toast_4597532" --- cannot analyze non-tables or special system tables". Well, OK then. Presumably this is by design, but it makes it impossible to get a true guesstimate (as of latest ANALYZE) of size. Are there any known workarounds? Thanks, P -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
