Re: Estimating space required for indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Estimating space required for indexes
Дата
Msg-id 18269.1051540901@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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>)
Re: Estimating space required for indexes  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Ralph Graulich
Дата:
Сообщение: old thread: Migration from mySQL to postgreSQL
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Estimating space required for indexes