Re: database size including indexes

From: Yann Ramin <atrus(at)atrustrivalie(dot)org>
To: "Culley Harrelson" <culleyharrelson(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: database size including indexes
Date: 2001-05-28 01:21:21
Message-ID: 01052718212104.00382@atp.atpn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


The unix command 'du' is your friend. Just run that in the right data subdir
for your database.

On Saturday 26 May 2001 06:41 am, Culley Harrelson wrote:
> Hi,
>
> Is there anyway to determine the total size of a database (including
> indexes)?
>
> Culley
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--

--------------------------------------------------------------------
Yann Ramin atrus(at)atrustrivalie(dot)org
Atrus Trivalie Productions www.redshift.com/~yramin
AIM oddatrus
Marina, CA http://profiles.yahoo.com/theatrus

IRM/IRT Developer DVfootage.com developer
SNTS Developer KLevel Developer

When smashing monuments, save the pedstals -- they always come in handy.
-- Stanislaw J. Lem, "Unkempt Thoughts"

Nothing succeeds like excess.
- Winston Churchill

Deep in the human unconscious is a pervasive need for a logical
universe that makes sense. But the real universe is always one step
beyond logic.
- Muad'Dib (Dune, Frank Herbert)
--------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Per-Olof Pettersson 2001-05-28 02:19:14 Re: Windows SQL query interface
Previous Message Farid Hajji 2001-05-28 00:18:38 Re: Trouble with strange OUTER JOIN syntax