Re: Attribute Alignment - Mailing list pgsql-hackers

From Michael Richards
Subject Re: Attribute Alignment
Date
Msg-id 056701c0686a$e02d9680$0200a8c0@digitallis
Whole thread Raw
In response to More Tuple Madness  ("Michael Richards" <miker@interchange.ca>)
Responses Re: Attribute Alignment  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is this alignment relative to the beginning of the page or tuple, or even
the tuple data area (after the tuple header)?

-Michael

> "Michael Richards" <miker@interchange.ca> writes:
> > The alignment seems to be wrong for type CHAR(1):
>
> No, the alignment is fine.  A field's align constraint says where it has
> to start, not where the next field has to start.  gender starts on a
> 4-byte boundary and is 5 bytes long, then we have one byte wasted for
> alignment of yearofbirth, then yearofbirth starts on a 2-byte boundary.
> Everyone's happy.
>
> regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Manual changes for ALTER TABLE OWNER
Next
From: Oleg Bartunov
Date:
Subject: Who is a maintainer of GiST code ?