On Wed, 01 Sep 2010 12:35:02 +0200, damien clochard <damien(at)dalibo(dot)info>
wrote:
The results isn't exactly accurate, I tried it on my svr:
* your select: 12.0000
* du -sh /var/lib/..../<db_nb by oid2name>/: 13M
NOTE: du -sh gives the *theorical* (bytes) occupation on HD (don't take
care of disk blocks not entirely filled, so the *real* occupation
is usually >; might be ~13.5M)
> SELECT datname,
> pg_database_size(datname)::float/1024/1024
> FROM pg_database;
--
Q: Why don't lawyers go to the beach?
A: The cats keep trying to bury them.