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

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Need to calculate total size of a table along with BLOB data assosciated with it.
Date: 2015-09-18 11:39:50
Message-ID: CAKKd064QZgHMM6sLqoX0qnyXED60Vv8fwN2mF9BvR8zCehAfyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2015-09-18 11:53:22 Re: Need to calculate total size of a table along with BLOB data assosciated with it.
Previous Message Albe Laurenz 2015-09-18 07:35:29 Re: string not equal query, postgresql 9.4.4