On Tue, Jul 18, 2017 at 7:21 AM, Mikhail wrote:
> Hi guys,
>
> I'm running the process, that executes "select * from sr where sr.id=210
> for update;", then some calculations and finally "update sr set usage =
> where sr.id = 210;". That operation is done in a loop.
>
> In parallel session i'm r
Hi guys,
I'm running the process, that executes "select * from sr where sr.id=210 for
update;", then some calculations and finally "update sr set usage =
where sr.id = 210;". That operation is done in a loop.
In parallel session i'm running the query:
test=# explain (analyze, buffers) select i