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 ο/η Antonio Vieiro έγραψε:
> 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
>
--
Achilleas Mantzios