Thread: limit connections pgpool
Hi, i want to know what is the pgpool parameter for close the connections directly in the database, because the pgpool II close fine the the childs with the life time, but the connection in the database continue open in idle state. this is my pool config num_init_children = 100 max_pool = 8 child_life_time = 60 child_max_connections = 0 connection_life_time = 0 client_idle_limit = 60 and this is my postgresql.conf max_connections = 800 shared_buffers = 2048MB temp_buffers = 64MB work_mem = 2048MB maintenance_work_mem = 2048MB wal_buffers = 256 checkpoint_segments = 103 thanks
On Fri, Oct 11, 2013 at 12:00 AM, Jeison Bedoya Delgado <jeisonb@audifarma.com.co> wrote: > Hi, i want to know what is the pgpool parameter for close the connections > directly in the database, because the pgpool II close fine the the childs > with the life time, but the connection in the database continue open in idle > state. You should ask that directly to the pgpool mailing lists: http://www.pgpool.net/mediawiki/index.php/Mailing_lists Regards, -- Michael
> Hi, i want to know what is the pgpool parameter for close the > connections directly in the database, because the pgpool II close fine > the the childs with the life time, but the connection in the database > continue open in idle state. That's the result of connection cache functionality of pgpool-II. If you don't need the connection cache of pgpool-II at all, you could turn it off: connection_cache = off Or you could set following to non 0. connection_life_time After an idle connection to PostgreSQL backend lasts for connection_life_time seconds, the connection will be turned off. If you have further questions, you'd better to subscribe and post the question: http://www.pgpool.net/mailman/listinfo/pgpool-general -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > this is my pool config > > num_init_children = 100 > max_pool = 8 > child_life_time = 60 > child_max_connections = 0 > connection_life_time = 0 > client_idle_limit = 60 > > > and this is my postgresql.conf > > max_connections = 800 > shared_buffers = 2048MB > temp_buffers = 64MB > work_mem = 2048MB > maintenance_work_mem = 2048MB > wal_buffers = 256 > checkpoint_segments = 103 > > > thanks > > > -- > Sent via pgsql-performance mailing list > (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance