Re: Estimating space required for indexes - Mailing list pgsql-general

On Monday 28 April 2003 20:19, Shridhar Daithankar wrote:
> [ajit@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@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