From: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: limit connections pgpool
Date: Thu, 10 Oct 2013 10:00:51 -0500
Message-ID: <5256C123.1030103@audifarma.com.co> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jeisonb@audifarma.com.co
Subject: Re: limit connections pgpool
In-Reply-To: <5256C123.1030103@audifarma.com.co>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox