Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +285−10, All patches: +285−10

Topic

Server Features

Tags

My First Patch

Created

2025-10-13 12:53:52

Last modified

2025-10-13 12:54:23 (7 hours ago)

Latest email

2025-10-09 11:20:32 (4 days ago)

Status

PG19-3 (2025-11-01 – 2025-11-30): Needs review

Target version

Authors

Shayon Mukherjee (shayonj)

Reviewers

Committer

Links

Git

Emails

Proposal for discussions: Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive: First at 2025-10-07 16:54:07 by Shayon Mukherjee <shayonj at gmail.com>
Latest at 2025-10-09 11:20:32 by Shayon Mukherjee <shayonj at gmail.com>
Latest attachment (v2-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-09 11:20:32 from Shayon Mukherjee <shayonj at gmail.com>
    Attachment (v2-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-09 11:20:32 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-08 21:16:12 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-reads-to-proceed-during-FK-trigger-drops-by.patch) at 2025-10-07 16:54:07 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)

History

When	Who	What
2025-10-13 12:54:23	Shayon Mukherjee (shayonj)	Changed name to Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive
2025-10-13 12:53:52	Shayon Mukherjee (shayonj)	Attached mail thread CANqtF-q3G4pYj1e8fL7CW=UXjktn+Ek_q3tSC05i+zKWtv8RSA@mail.gmail.com
2025-10-13 12:53:52	Shayon Mukherjee (shayonj)	Created patch record