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-02-01 16:38:25 (3 weeks, 2 days ago)
Latest email 2023-12-31 15:02:58 (1 month, 3 weeks ago)
Status
2024-03: Needs review
2024-01: Moved to next CF
Target version 17
Authors Mikhail Zhilin (mizhka-at-pgpro)
Reviewers Become reviewer
Committer
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 2023-12-31 15:02:58 by Michael Zhilin <m.zhilin at postgrespro.ru>
Latest attachment (create_temp_tables.sql) at 2023-12-31 15:02:58 from Michael Zhilin <m.zhilin at postgrespro.ru>
    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-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