Message-ID: <5256C123.1030103@audifarma.com.co>
Date: Thu, 10 Oct 2013 10:00:51 -0500
From: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
Organization: Audifarma S.A.
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:17.0) Gecko/20130801 Thunderbird/17.0.8
MIME-Version: 1.0
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: limit connections pgpool
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance