> 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.
