Size of database

Started by TPCCUVAabout 24 years ago2 messagesgeneral
Jump to latest
#1TPCCUVA
TPCCUVA@terra.es

Does anyone know how to optain the size of a database?

Thanks.

#2Holger Krug
hkrug@rationalizer.com
In reply to: TPCCUVA (#1)
Re: Size of database

On Fri, Feb 22, 2002 at 12:21:00PM +0100, TPCCUVA wrote:

Does anyone know how to optain the size of a database?

What do you mean with `size' ? The space occupied on the file
system you can obtain this way:

# select oid from pg_database where datname='mybase';
oid
-------
17239
(1 row)

$ du -hs data/base/17239
13.5 M

--
Holger Krug
hkrug@rationalizer.com