Re: High concurrency same row (inventory)

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@entrata.com> wrote:

> Can you share the schema of the table(s) involved and an example or two of
> the updates being executed?
>