Re: possible deadlock: different lock ordering for heap pages

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Amit Kapila <amit.kapila16@gmail.com>

Cc: "Nishant, Fnu" <nishantf@amazon.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2019-01-31T19:00:44Z

Lists: pgsql-hackers

On Sun, Jan 20, 2019 at 9:55 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> Robert, can you please once see if we are missing anything here
> because to me the report and fix look genuine.

I think so, too.  I guess the probability of a deadlock here must be *very* low.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Avoid possible deadlock while locking multiple heap pages.
- 0b8bdb3c3ec0 12.0 landed
- fba0a8292997 9.4.21 landed
- 6a2c9c633135 9.5.16 landed
- 073afae81989 9.6.12 landed
- 1ca33fc7b511 10.7 landed
- 904413637f8b 11.2 landed
Try again to make the visibility map crash safe.
- e16954f3d27f 9.2.0 cited