Re: possible deadlock: different lock ordering for heap pages

Nishant, Fnu <nishantf@amazon.com>

From: "Nishant, Fnu" <nishantf@amazon.com>

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

Cc: Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2019-02-01T05:30:18Z

Lists: pgsql-hackers


On 1/31/19, 9:21 PM, "Amit Kapila" <amit.kapila16@gmail.com> wrote:


    > BTW, do you have a reproducible test case for this fix?  How did you
    catch this, browsing code?
    
Yes, I observed it while reading code. I do not have a repro.

    > How do we pronounce your name, is Nishant Fnu okay?  I would like to
    mention you as the author of the patch, so need to write your name.
Yes, Nishant Fnu is okay.

Thanks
Nishant

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