Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> 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.

Ah, I see. Followup: Does it make a measurable performance difference
for things like join or filtering operations, in case the storage size
ends up being the same?

//Magnus


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to