Re: [HACKERS] database size

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

In response to

Browse pgsql-hackers by date

  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