Re: [HACKERS] Two pass CheckDeadlock in contentent case

2017-10-03 Thread Sokolov Yura
On 2017-10-03 17:30, Sokolov Yura wrote: Good day, hackers. During hard workload sometimes process reaches deadlock timeout even if no real deadlock occurred. It is easily reproducible with pg_xact_advisory_lock on same value + some time consuming operation (update) and many clients. When

[HACKERS] Two pass CheckDeadlock in contentent case

2017-10-03 Thread Sokolov Yura
Good day, hackers. During hard workload sometimes process reaches deadlock timeout even if no real deadlock occurred. It is easily reproducible with pg_xact_advisory_lock on same value + some time consuming operation (update) and many clients. When backend reaches deadlock timeout, it calls