Tomasz Ostrowski wrote:
> The database would get an error on the connection socket only after it tries to read or write to it next time. But it does not try to do this - it's busy counting those quarks until statement_timeout is reached.
>
It is unfortunate that PostgreSQL does not take into account that the client has disconnected and does not need to process query.
I know only one non-stable utility that can solve your problem: https://github.com/yandex/odyssey <https://github.com/yandex/odyssey> (unfortunately pgbouncer can't do that).
--
Dmitry Vasiliev