Postgres Pro
Downloads
Home   >   mailing lists

Re: Table size does not include toast size - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table size does not include toast size
Date
Msg-id 14660.1261407697@sss.pgh.pa.us
Whole thread Raw
In response to Table size does not include toast size  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Responses Re: Table size does not include toast size  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Re: Table size does not include toast size  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Minimum perl version supported
Next
From: Tom Lane
Date:
Subject: Re: Minimum perl version supported