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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
