Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net> writes:
> OK, Option 2: I use an SSH connection to tunnel port 5432 from my Windows
> machine to the DB machine (Red Hat 7.3); occasionally the SSH connection
> drops, and so does the tunnel. Could that explain the temp tables?
Nope, don't like that either. It might take a little while for the
kernel to realize the connection is dead, but once it does, the backend
will see EOF on its input and will clean up and exit.
regards, tom lane