Add client connection check during the execution of the query

From: s(dot)cherkashin(at)postgrespro(dot)ru
To: pgsql-hackers(at)postgresql(dot)org
Subject: Add client connection check during the execution of the query
Date: 2018-11-19 15:22:42
Message-ID: 77def86b27e41f0efcba411460e929ae@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This patch adds verification of the connection with the client during
the execution of the SQL query. The feature enables using the GUC
variable ‘client_connection_check_interval’. The default check interval
is 1 second. If you set the value of ‘client_connection_check_interval’
to 0, then the check will not be performed.
The feature will be useful in cases when, during the execution of a very
long query, the client suddenly terminates the connection - this will
allow backend to cancel further execution of the query and free server
resources.

Attachment Content-Type Size
Add_client_connection_check.patch text/x-diff 11.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2018-11-19 15:39:15 Re: your mail
Previous Message Adelino Silva 2018-11-19 14:54:13