Tobias Lott <tobias.lott@xxxxxxxxxxxx> writes: > There were no crashes of the instance, but some issues with the connected > application, resulting in 'could not receive data from client: Connection > reset by peer' and 'unexpected EOF on client connection with an open > transaction'. No, that sort of thing would still allow the backend to shut down cleanly. > So if this might have left behind temp tables causing the errors, should I > try to delete these pg_temp tables? It would definitely be worth looking around to see if you have any temp tables that shouldn't be there. I think you can just do \dt pg_temp_*.* in psql (as superuser) to see what's out there. Figuring out which ones are live sessions' temp tables might be harder, though. regards, tom lane
