Re: Estimating space required for indexes

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