Postgres Pro
Downloads
Home   >   mailing lists

Re: Built-in connection pooler - Mailing list pgsql-hackers

From Ryan Lambert
Subject Re: Built-in connection pooler
Date
Msg-id CAN-V+g852qfYNhQyd-s+Ar0dkOLK9pzVUdmHwO-LwDdQLn0CyQ@mail.gmail.com
Whole thread Raw
In response to Re: Built-in connection pooler  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Built-in connection pooler  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
List pgsql-hackers
Tree view

I attached to this mail patch which is fixing both problems: correctly 
reports error to the client and calculates  number of idle clients).

Yes, this works much better with max_sessions=1000.  Now it's handling the 300 connections on the small server.   n_idle_clients now looks accurate with the rest of the stats here.

postgres=# SELECT n_clients, n_backends, n_idle_backends, n_idle_clients FROM pg_pooler_state();
 n_clients | n_backends | n_idle_backends | n_idle_clients
-----------+------------+-----------------+----------------
       150 |         10 |               9 |            149
       150 |         10 |               6 |            146


Ryan Lambert


pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Global temporary tables
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Small patch to fix build on Windows