Re: Estimating space required for indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Estimating space required for indexes
Date: 2003-04-28 14:41:41
Message-ID: 18269.1051540901@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
> With these overheads it turns out that,
> disk space for table= 8.1M*40=324MB
> disk space for index=8.1M*20*1.5=243MB
> On disk actually, 5.9GB is gone, as I mentioned earlier.

Into what? Look in the database directory and show us the file sizes.
contrib/pgstattuple might be useful as well.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2003-04-28 14:44:00 Re: Estimating space required for indexes
Previous Message Ralph Graulich 2003-04-28 14:36:51 old thread: Migration from mySQL to postgreSQL