Concurrency issue under very heay loads
| От | Raji Sridar (raji) |
|---|---|
| Тема | Concurrency issue under very heay loads |
| Дата | |
| Msg-id | 69520586F2CA1444B3F6BE05187B9ABAAC97D4@xmb-sjc-226.amer.cisco.com обсуждение исходный текст |
| Ответы |
Re: Concurrency issue under very heay loads
Re: Concurrency issue under very heay loads Re: [PERFORM] Concurrency issue under very heay loads Re: [PERFORM] Concurrency issue under very heay loads Re: Concurrency issue under very heay loads Re: Concurrency issue under very heay loads Re: [PERFORM] Concurrency issue under very heay loads |
| Список | pgsql-general |
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 по дате отправления: