Re: Estimating space required for indexes

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Estimating space required for indexes
Date: 2003-04-28 14:57:16
Message-ID: 200304282027.16194.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 28 April 2003 20:19, Shridhar Daithankar wrote:
> [ajit(at)jejuri dbs]$ du -h
> 3.6M ./base/1
> 3.6M ./base/16975
> 5.9G ./base/16976
> 6.0G ./base
> 132K ./global
> 8.0K ./pg_clog
> 128M ./pg_xlog
> 6.1G .

Sorry, forgot this last time..

nav=# select relfilenode from pg_class where relname='height';
relfilenode
-------------
16977
(1 row)

nav=# \q
[ajit(at)jejuri dbs]$ find . -name 16977
./base/16976/16977

Shridhar

--
If A equals success, then the formula is _A = _X + _Y + _Z. _X is work.
_Y
is play. _Z is keep your mouth shut.
-- Albert Einstein

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-28 14:59:31 Re: Estimating space required for indexes
Previous Message scott.marlowe 2003-04-28 14:55:46 Re: Solaris