Postgres Pro
Downloads
Home   >   mailing lists

Re: Padding on 64-bit - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Padding on 64-bit
Date
Msg-id 16727.1180467866@sss.pgh.pa.us
Whole thread Raw
In response to Padding on 64-bit  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Padding on 64-bit  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Tree view 
Magnus Hagander <magnus@hagander.net> writes:
> Specifically, I'm interested if I actually end up making my table any
> smaller if I move from 64-bit integer primary key to 32-bit.

Depends what else is in the row ... the overall row will get padded to
MAXALIGN, but if you were wasting 4 bytes on alignment before, then you
win.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Create hooks to let a loadable plugin monitor (or even replace)
Next
From: Magnus Hagander
Date:
Subject: Re: Padding on 64-bit