Primary key generation in cluster (PostgreSQL)

From: Andreas Hartmann (andrea..pache.org)
Date: Mon Jan 04 2010 - 18:35:27 EST

Next message: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"

Next in thread: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"
Reply: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Cayenne community,

I'm using Cayenne 3.0M6.

Is it safe to use the default primary key generation strategy with
PostgreSQL in a web application cluster, with multiple JVMs accessing
the same database?

IIUC Cayenne fetches the next value from the sequence (which is then
incremented by 20) and uses these 20 keys. So theoretically, no two
Cayenne instances should ever use the same key. Is this assumption correct?

Thanks a lot for any hints and best regards,

-- Andreas

-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01

Next message: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"
Next in thread: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"
Reply: Andrus Adamchik: "Re: Primary key generation in cluster (PostgreSQL)"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon Jan 04 2010 - 18:37:39 EST