Re: Update concurrency - Mailing list pgsql-general

From David G. Johnston
Subject Re: Update concurrency
Date
Msg-id CAKFQuwbDjaigik_HBiW90WtorFeeEQEw_e+jBdR2jiCCbQ42Zw@mail.gmail.com
Whole thread Raw
In response to Update concurrency  (Sylvain Déve <sylvain.deve@protonmail.com>)
List pgsql-general
On Monday, December 20, 2021, Sylvain Déve <sylvain.deve@protonmail.com> wrote:

To summarize, how can I allow for multiple updates of the same attributes, one after another, even when these updates are requested almost at the same time from independent, uncontrollable client requests?

Most people use an application connect pool.  You replace “connect” with a call to get a connection from the pool.  When you are done you release the connect back to the pool.  Concurrency is then done by having a pool size greater than one.  If you try doing more concurrent work than the pool size allows the pool call should block and/lr return a nothing upon which you loop and try again.

David J.

pgsql-general by date:

Previous
From: Sylvain Déve
Date:
Subject: Update concurrency
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: md5 issues Postgres14 on OL7