On Mon, Aug 25, 2008 at 10:23 AM, Mark Roberts <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
