Re: [HACKERS] database size

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: darrenk@insightdist.com (Darren King)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-01-07T19:26:49Z
Lists: 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