Postgres Pro
Downloads
Home   >   mailing lists

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

From Radoslaw Smogura
Subject Re: Choosing primary key type: 64 or 52 bit primary keys?
Date
Msg-id 20110722073444.6C3B0B5DC0C@mail.postgresql.org
Whole thread Raw
In response to Choosing primary key type: 64 or 52 bit primary keys?  (Antonio Vieiro <antonio@antonioshome.net>)
List pgsql-general
Tree view 
I think there is no difference in indexing int or floats. Only one difference is speed of comparison of this
numbers.

Ifyou create normal system use 64bit ints.  

------------------------
Regards,
Radoslaw Smogura
(mobile) 

-----Original Message-----
From: Antonio Vieiro
Sent: 22 lipca 2011 09: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 of a 'double precision'

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

Thanks in advance,
Antonio

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Antonio Vieiro
Date:
Subject: Choosing primary key type: 64 or 52 bit primary keys?
Next
From: Jenish Vyas
Date:
Subject: Re: Maximum number of client connection supported by Postgres 8.4.6