Στις 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,
^^^^^^^^^^
oops sorry i mean "less straight forward"
> 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
>
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
