[pgpool-general: 8536] DISCARD ALL connections in idle

Avi Raboah avi.raboah at gmail.com
Tue Jan 3 20:30:14 JST 2023


Hi,

I am using 30 num_childs with connection pooling on and child_life_time 0.

I am not sure why but when I am looking on the pg_stat_activity I can see
29 connection in idle state and the query is DISCARD ALL.

And after some time the application name changed to psql in all the
connection.

I looking in the code but didn’t find anything about the DISCARD ALL query.

I can guess maybe it’s related for the connection reuse but still can’t
explain why the query appears as DISCARD_ALL.

Thanks for your help

Avi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230103/da99d579/attachment.htm>


More information about the pgpool-general mailing list