Re: db size and tables size difference - Mailing list pgsql-admin

From Tom Lane
Subject Re: db size and tables size difference
Date
Msg-id 9011.1253744846@sss.pgh.pa.us
Whole thread Raw
In response to Re: db size and tables size difference  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
Responses db size and tables size difference  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> writes:
> The issue may be   with pg_size_pretty()  results, I don't have details
> knowledge of this function.

I doubt it, that's a pretty simple function ... but if you don't trust
it, just remove the pg_size_pretty call and look directly at the output
of the size functions.

> select pg_size_pretty(pg_database_size('db1'));

Just to double check here ... you're sure you're naming the correct
database in this call?

            regards, tom lane

pgsql-admin by date:

Previous
From: Isabella Ghiurea
Date:
Subject: Re: db size and tables size difference
Next
From: Mihail Nasedkin
Date:
Subject: pg_toast record in table pg_class