pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re

pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re

pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re

pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re

pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re

pgsql: Avoid deadlock during orphan temp table removal.

2024-04-02 Thread Tom Lane
Avoid deadlock during orphan temp table removal. If temp tables have dependencies (such as sequences) then it's possible for autovacuum's cleanup of orphan temp tables to deadlock against an incoming backend that's trying to clean out the temp namespace for its own use. That can happen because Re