From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | darrenk(at)insightdist(dot)com (Darren King) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] database size |
Date: | 1998-01-07 19:26:49 |
Message-ID: | 199801071926.OAA22050@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-01-07 19:41:21 | varchar size |
Previous Message | Darren King | 1998-01-07 18:03:07 | Re: [HACKERS] database size |