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
:01
To: pgsql
Subject: [GENERAL] Choosing primary key type: 64 or 52 bit primary keys?
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
bigint by all means. floating point arithmetic is somewhat more
bloated/fuzzy/straight forward than integer,
and even if postgresql was perfect regarding floating point comparisons, no one
can claim
the same for client languages. So define your PK as bigint.
Στις Friday 22 July 2011 10:01:58
Στις Friday 22 July 2011 13:25:21 ο/η Achilleas Mantzios έγραψε:
bigint by all means. floating point arithmetic is somewhat more
bloated/fuzzy/straight forward than integer,
