Re: Table size does not include toast size
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rafael Martinez <r.m.guerrero@usit.uio.no>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-12-21T15:01:37Z
Lists: pgsql-hackers
Rafael Martinez <r.m.guerrero@usit.uio.no> writes: > I wonder why the function pg_relation_size(text) does not take into > account the space used by toast data in a table when returning the space > used by the table. It's not supposed to. Use pg_total_relation_size if you want a number that includes index and toast space. regards, tom lane