Hi, I'm sorry for the long lull. Considering that it is still important for some users to be able to clean other sessions' temporary directories, I suggest adding a GUC that will allow superuser to do this. We keep only one option - to drop tables, because only this feature works properly in postgres by now.
The ability to read and modify other session's temp tables is broken (I mean INSERT, UPDATE, DELETE, SELECT queries) and needs to be disabled. I wrote about broken INSERTs here : https://www.postgresql.org/message-id/CAJDiXgj6TBzn%3D6Ezx7%2B9BNa9HpBitBU%2BMuv-N3mHeN_Zs3NBDw%40mail.gmail.com What do you think about this idea? -- Best regards, Daniil Davydov