Choosing primary key type: 64 or 52 bit primary keys? - Mailing list pgsql-general

From Antonio Vieiro
Subject Choosing primary key type: 64 or 52 bit primary keys?
Date
Msg-id CAPHN3JVGz0pFLUf-bQC-A8bLvSHOXfdegUpSA6tg4axGu=68ow@mail.gmail.com
Whole thread Raw
Responses Re: Choosing primary key type: 64 or 52 bit primary keys?
List pgsql-general
Hi all,

I'd like to use an integer number for my primary key. I need it to be
bigger than 32 bits.

As far as I understand I have two options:

a) use all the 64 bits of a 'bigint'
b) use the 52 mantissa bits of a 'double precision'

My question is, which would be faster for indexing? I assume the
bigint wins here, right?

Thanks in advance,
Antonio

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Building an home computer for best Poker Tracker performance
Next
From: Radoslaw Smogura
Date:
Subject: Re: Choosing primary key type: 64 or 52 bit primary keys?