Re: db size and tables size difference

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: db size and tables size difference
Date: 2009-09-23 22:27:26
Message-ID: 9011.1253744846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mihail Nasedkin 2009-09-24 05:45:02 pg_toast record in table pg_class
Previous Message Isabella Ghiurea 2009-09-23 22:11:05 Re: db size and tables size difference