Search Postgresql Archives

Re: Update concurrency

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Monday, December 20, 2021, Sylvain Déve <sylvain.deve@xxxxxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux