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 <[email protected]> Reviewed-by: Chao Li <[email protected]> Reviewed-by: Zsolt Parragi <[email protected]> Discussion: https://postgr.es/m/[email protected] Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a0a0c0c20ec5f8787bb1be5f476c4e59f6810634 Modified Files -------------- src/backend/commands/repack.c | 25 ++++++++++++++++++++++++- src/backend/commands/vacuum.c | 5 +++++ 2 files changed, 29 insertions(+), 1 deletion(-)
