Re: [GENERAL] Choosing primary key type: 64 or 52 bit primary keys?

I think there is no difference in indexing int or floats. Only one difference is speed of comparison of this numbers. If you create normal system use 64bit ints. Regards, Radoslaw Smogura (mobile) -Original Message- From: Antonio Vieiro Sent: 22 lipca 2011 09

Re: [GENERAL] Weird problem that enormous locks

Simple and obvious question right now do You call commit after transaction? If yes do you use any query or connection pooler? Regards, Radoslaw Smogura (mobile) -Original Message- From: Tony Wang Sent: 15 lipca 2011 03:51 To: Scott Marlowe Cc: PostgreSQL Subject

Re: [GENERAL] Weird problem that enormous locks

Once time I've read 9.x PostgreSQL locks everything before offset, if You execute select for update offset. Do you call such query at least once? It's the way why we think about having 9.x server. Regards, Radoslaw Smogura (mobile) -Original Message-

Re: [GENERAL] Real type with zero

Your question may suggest you are more interested in storing value, as decimal not real, it's more secure to use this way for moneys, but even with decimal your trailing zeros may be removed. Regards, Radoslaw Smogura -Original Message- From: Condor Sent: 29 czerwca 2011 13:

Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".

Basic question in Windows - Did you turned of UAC -Original Message- From: Adrian Klaver Sent: 28 czerwca 2011 16:40 To: pgsql-general@postgresql.org Cc: Michael Gould Subject: Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty". On Monday, June 27, 2011 5:

Re: [GENERAL] Reusing cached prepared statement slow after 5 executions

This behavior is in some way needed, as PreparedStatement is, commonly, used once, just to pass parameters without escaping. Regards, Radek -Original Message- From: Rob Gansevles Sent: 27 czerwca 2011 08:50 To: pgsql-general Subject: Re: [GENERAL] Reusing cached prepared statement slow a