El 16/10/18 a las 12:12, Nicola Contu escribió: > 2492534808 | dev | 7355 | 1833427130 | pgbouncer | > | 10.151.2.145 | | 60570 | > 2018-10-16 14:13:05.151015+00 | | > 2018-10-16 15:10:40.309993+00 | 2018-10-16 15:10:40.310038+00 | Client > | ClientRead | idle | | | DISCARD ALL > > They are idle actually. > Will they count as client connection on the total amount set on the > postgres.conf?
Yes, but that's the idea of having a pooler in between the app and the server. Whenever the app needs a new connection it will reuse one from the pool, instead of having to open a new connection. pgbouncer will eventually close the connection if it stays in the pool for longer than server_lifetime or server_idle_timeout. Regards, -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
