Re: [HACKERS] database size - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] database size
Date
Msg-id 199801071926.OAA22050@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] database size  (darrenk@insightdist.com (Darren King))
List 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 by date:

Previous
From: darrenk@insightdist.com (Darren King)
Date:
Subject: Re: [HACKERS] database size
Next
From: Bruce Momjian
Date:
Subject: varchar size