pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r

pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r

pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r

pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r

pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r

pgsql: Avoid possible deadlock while locking multiple heap pages.

2019-02-02 Thread Amit Kapila
Avoid possible deadlock while locking multiple heap pages. To avoid deadlock, backend acquires a lock on heap pages in block number order. In certain cases, lock on heap pages is dropped and reacquired. In this case, the locks are dropped for reading in corresponding VM page/s. The issue is we r