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