Postgres Pro
Downloads
Home   >   mailing lists

Need to calculate total size of a table along with BLOB data assosciated with it. - Mailing list pgsql-admin

From girish R G peetle
Subject Need to calculate total size of a table along with BLOB data assosciated with it.
Date
Msg-id CAKKd064QZgHMM6sLqoX0qnyXED60Vv8fwN2mF9BvR8zCehAfyg@mail.gmail.com
Whole thread Raw
Responses Re: Need to calculate total size of a table along with BLOB data assosciated with it.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hi,
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. 

Thanks
Girish

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: string not equal query, postgresql 9.4.4
Next
From: Albe Laurenz
Date:
Subject: Re: Need to calculate total size of a table along with BLOB data assosciated with it.