Re: Update blocking another update

2018-01-15 Thread Guillaume Lelarge
2018-01-12 8:25 GMT+01:00 Sachin Kotwal : > Hi All, > > As update operation is "ROW Exclusive" It should not block another update > operation. > > As long as two processes don't try to update the same row. In below case we are updating all values for in one column. > > It is blocking another upda

Update blocking another update

2018-01-11 Thread Sachin Kotwal
Hi All, As update operation is "ROW Exclusive" It should not block another update operation. In below case we are updating all values for in one column. It is blocking another update operations. It this expected behavior ? Please clarify . 1. Setup database by initializing with pgbench with so