[ADMIN] my table is empty, pg_relation_size(name) return 38 MB

Hi Team, Though my table is empty, pg_relation_size(name) return 38 MB. I use below query to determine tables disk usages. SELECT nspname || '.' || relname AS "Table", pg_total_relation_size(C.oid) "Size", pg_size_pretty(pg_total_relation_size(C.oid)) AS "Total size" FROM pg_class C L

Re: [ADMIN] my table is empty, pg_relation_size(name) return 38 MB

Shivakumar Ramannavar wrote: > Though my table is empty, pg_relation_size(name) return 38 MB. I > use below query to determine tables disk usages. > > SELECT nspname || '.' || relname AS "Table", > pg_total_relation_size(C.oid) "Size", > pg_size_pretty(pg_total_relation_size(C.oid)) AS