> One gotcha about Postgres queries is that running queries do not get cancelled when the client disconnects
You can configure that these days, at least if the server is running on some common platforms:
https://www.postgresql.org/docs/current/runtime-config-conne...