Hello,
I've run an update query inside command line tool (psql) then I've exit the tool (closing the window).
When I re-logged in, I've noticed in pg_stat_activity that my query was still running.
I used the command pg_cancel_backend with the right PID, but it returned "f" few seconds later.
I re-checked pg_stat_activity and I was not able to see my query; there was only an autovacuum running on the table impacted by my query.
Since my update query usually takes about one hour, I was wandering what happened.
Is postgres regularly checking command line session? If session has expired, would postgres stop the query and rollback it?
I'm using both client and server v10.1.
Thanks in advance.