Re: Need to calculate total size of a table along with BLOB data assosciated with it.

girish R G peetle wrote:
> PostgreSQL system function, pg_total_relation_size() doesn't include BLOB data size that is associated
> with the table.
> 
> TAR dump restore fails if the BLOB data size associated with a table is more than 8GB. (Which is
> limitation of TAR format).
> 
> I know we can switch to compressed dump format. But wanted to know if there a way to know true size of
> a table.

Not easily, because technically, large objects don't belong to a table.

You'd have to write your own that scans the table and adds the size of
all referenced large objects.
It can probably be done in one SELECT using lo_lseek.

Yours,
Laurenz Albe