Re: Size of database - Mailing list pgsql-general

From Holger Krug
Subject Re: Size of database
Date
Msg-id 20020222124403.A1995@dev12.rationalizer.com
Whole thread Raw
In response to Size of database  (TPCCUVA <TPCCUVA@terra.es>)
List pgsql-general
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

pgsql-general by date:

Previous
From: TPCCUVA
Date:
Subject: Size of database
Next
From: Marcelo Pereira
Date:
Subject: Select <-> Case Insensitive