Skip other sessions' temp tables in REPACK, CLUSTER, and VACUUM FULL
Álvaro Herrera <alvherre@kurilemu.de>
Skip other sessions' temp tables in REPACK, CLUSTER, and VACUUM FULL get_tables_to_repack() and get_all_vacuum_rels() were including other sessions' temporary tables in their output work list, causing REPACK, CLUSTER and VACUUM FULL (when executed without a table list) to attempt to acquire AccessExclusiveLock on them, potentially blocking for an extended time. Fix by skipping other-session temp tables early, before they are added to the list. This issue is ancient, but there have been no complaints about it that I know of, so I'm opting for not backpatching at present. Author: Jim Jones <jim.jones@uni-muenster.de> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Zsolt Parragi <zsolt.parragi@percona.com> Discussion: https://postgr.es/m/0b555318-2bf2-46df-9377-09629a2a59db@uni-muenster.de
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/repack.c | modified | +24 −1 |
| src/backend/commands/vacuum.c | modified | +5 −0 |
Discussion
- VACUUM FULL, CLUSTER, and REPACK block on other sessions' temp tables 14 messages · 2026-03-24 → 2026-05-06