> Do you mean that the statement hadn't been fully transmitted yet?
Yes. Sending 2 MB takes most of time so client is terminated in this stage.
> If so, the backend would have just been waiting for the rest of the
> statement to arrive. Perhaps you're looking at some sort of network bug
> that caused the backend not to be told that the connection was lost.
If so why pgAdmin Cancel command does not terminate the process ? If process
is waiting for data,
Cancel signal sent through pgAdmin should terminate process immediately.
Andrus.