Avoid deadlock and concurrency during orphan temp table removal

Edit
Title Avoid deadlock and concurrency during orphan temp table removal
Topic Bug Fixes
Created 2023-12-31 15:04:45
Last modified 2024-04-02 18:59:59 (2 months, 2 weeks ago)
Latest email 2024-04-04 09:51:48 (2 months, 2 weeks ago)
Status
2024-03: Committed
2024-01: Moved to next CF
Target version 17
Authors Mikhail Zhilin (mizhka-at-pgpro)
Reviewers Akshat Jaimini (akshatj)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences
First at 2023-12-31 15:02:58 by Michael Zhilin <m.zhilin at postgrespro.ru>
Latest at 2024-04-04 09:51:48 by Akshat Jaimini <destrex271 at gmail.com>
Latest attachment (v2-0001-Avoid-deadlock-and-concurrency-during-orphan-temp.patch) at 2024-03-28 06:32:58 from "Andrey M. Borodin" <x4mmm at yandex-team.ru>
    Attachment (v2-0001-Avoid-deadlock-and-concurrency-during-orphan-temp.patch) at 2024-03-28 06:32:58 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (create_temp_tables.sql) at 2023-12-31 15:02:58 from Michael Zhilin <m.zhilin at postgrespro.ru> (Patch: No)
History
When Who What
2024-04-02 18:59:59 Tom Lane (tgl) Closed in commitfest 2024-03 with status: Committed
2024-04-02 18:04:19 Tom Lane (tgl) Added tgl as committer
2024-03-29 10:31:01 Akshat Jaimini (akshatj) Posted review with messageid <171170826140.2046436.12738244831107414180.pgcf@coridan.postgresql.org>
2024-03-29 10:31:01 Akshat Jaimini (akshatj) New status: Ready for Committer
2024-03-28 05:51:07 Akshat Jaimini (akshatj) Posted comment with messageid <171160506729.2046434.11023887986424565034.pgcf@coridan.postgresql.org>
2024-03-12 06:40:14 Akshat Jaimini (akshatj) Added akshatj as reviewer
2024-02-01 16:38:25 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-31 15:05:04 Mikhail Zhilin (mizhka-at-pgpro) Changed authors to Mikhail Zhilin (mizhka-at-pgpro)
2023-12-31 15:05:04 Mikhail Zhilin (mizhka-at-pgpro) Changed targetversion to 17
2023-12-31 15:04:45 Mikhail Zhilin (mizhka-at-pgpro) Attached mail thread c43ce028-2bc2-4865-9b89-3f706246eed5@postgrespro.ru
2023-12-31 15:04:45 Mikhail Zhilin (mizhka-at-pgpro) Created patch record
Edit