Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Concurrency issue under very heay loads - Mailing list pgsql-general

From ramasubramanian
Subject Re: [PERFORM] Concurrency issue under very heay loads
Date
Msg-id 28022EE0B1F94CE59A0C270DE78D4571@ramasubramanian
Whole thread Raw
In response to Concurrency issue under very heay loads  ("Raji Sridar (raji)" <raji@cisco.com>)
List pgsql-general
Tree view
Hi,
Are you using automatic sequence increment in table?
----- Original Message -----
Sent: Thursday, July 16, 2009 10:29 AM
Subject: [PERFORM] Concurrency issue under very heay loads

Hi,
 
We use a typical counter within a transaction to generate order sequence number and update the next sequence number. This is a simple next counter - nothing fancy about it.  When multiple clients are concurrently accessing this table and updating it, under extermely heavy loads in the system (stress testing), we find that the same order number is being generated for multiple clients. Could this be a bug? Is there a workaround? Please let me know.
 
Thanks
Raji

pgsql-general by date:

Previous
From: "Raji Sridar (raji)"
Date:
Subject: Concurrency issue under very heay loads
Next
From: Greenhorn
Date:
Subject: Re: Concurrency issue under very heay loads