"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Is it normal for a long query to keep running after I close the psql
> session that initiated it?
Yes, the backend will typically not notice a client disconnect until it
next tries to read a command.
regards, tom lane