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

Поиск
Список
Период
Сортировка
От girish R G peetle
Тема Need to calculate total size of a table along with BLOB data assosciated with it.
Дата
Msg-id CAKKd064QZgHMM6sLqoX0qnyXED60Vv8fwN2mF9BvR8zCehAfyg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need to calculate total size of a table along with BLOB data assosciated with it.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: string not equal query, postgresql 9.4.4
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Need to calculate total size of a table along with BLOB data assosciated with it.