Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Estimating space required for indexes
Date
Msg-id 18269.1051540901@sss.pgh.pa.us
Whole thread Raw
In response to Re: Estimating space required for indexes  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Estimating space required for indexes  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Re: Estimating space required for indexes  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
Shridhar Daithankar <shridhar_daithankar@persistent.co.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

pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: old thread: Migration from mySQL to postgreSQL
Next
From: Oleg Bartunov
Date:
Subject: Re: Estimating space required for indexes