Re: High concurrency same row (inventory)

The UPDATE was something like:

UPDATE bucket SET qty_available = qty_available + 1 WHERE bucket_uid =
0940850938059380590

Thanks for all your help guys!

On Mon, Jul 29, 2019 at 9:04 PM Jean Baro <jfbaro(at)gmail(dot)com> wrote:

> All the failures come from the Bucket Table (see image below).
>
> I don't have access to the DB, neither the code, but last time I was
> presented to the UPDATE it was changing (incrementing or decrementing)
> *qty_available*, but tomorrow morning I can be sure, once the developers
> and DBAs are back to the office. I know it's quite a simple UPDATE.
>
> Table is called Bucket:
> {autovacuum_vacuum_scale_factor=0.01}
>
> [image: Bucket.png]
>
>
> On Mon, Jul 29, 2019 at 3:12 PM Michael Lewis <mlewis(at)entrata(dot)com> wrote:
>
>> Can you share the schema of the table(s) involved and an example or two
>> of the updates being executed?
>>
>