On Mon, Aug 25, 2008 at 10:23 AM, Mark Roberts <mailing_lists@xxxxxxxxxxxxxxx> wrote: > > On Thu, 2008-08-21 at 13:53 -0600, Scott Marlowe wrote: >> Regular SERIAL type is limited to a 32 bit int. BIGSERIAL uses a 64 >> bit int. > > I think one of the things that would be offsetting is the size > difference between the two types (32 vs 64 bits, 5 foreign keys, and a > billion rows or so makes for alot of pain). Well, of course a 64 bit int is gonna be bigger than a 32 bit, but with alignment issues and on 64 bit hardware, I'm guessing the difference isn't exactly twice as slow / twice as much storage. And it's way faster than a GUID which was what I think started this thread.
