Re: [HACKERS] database size

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] database size
Дата
Msg-id 199801071926.OAA22050@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] database size  (darrenk@insightdist.com (Darren King))
Список pgsql-hackers
> A little more accurate by including the tuple rounding before storage.  For
> me the above would still be true if there is one or two int4s since the four
> bytes I would save would be taken back by the double-word tuple alignment.
>
> With the current src tree...again, all with aix alignment...
>
>  40 bytes + each row header
>   8 bytes + two int fields @ 4 bytes each
> --------- =
>  48 bytes per tuple (round up to next highest mulitple of 8)
>   4 bytes + pointer on page to tuple
> --------- =
>  52 bytes per tuple
>

Thanks.  Updated FAQ.

--
Bruce Momjian
maillist@candle.pha.pa.us

В списке pgsql-hackers по дате отправления:

Предыдущее
От: darrenk@insightdist.com (Darren King)
Дата:
Сообщение: Re: [HACKERS] database size
Следующее
От: Bruce Momjian
Дата:
Сообщение: varchar size