Re: Size of database

From: Holger Krug <hkrug(at)rationalizer(dot)com>
To: TPCCUVA <TPCCUVA(at)terra(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Size of database
Date: 2002-02-22 11:44:03
Message-ID: 20020222124403.A1995@dev12.rationalizer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rationalizer(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman 2002-02-22 11:49:23 funciton returning result of a select statement
Previous Message TPCCUVA 2002-02-22 11:21:00 Size of database