| From: | Jeison Bedoya Delgado <jeisonb(at)audifarma(dot)com(dot)co> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | limit connections pgpool |
| Date: | 2013-10-10 15:00:51 |
| Message-ID: | 5256C123.1030103@audifarma.com.co |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-10-10 21:44:30 | Re: postgreSQL query via JDBC in different OS taking different running time? |
| Previous Message | Marcelo Vega | 2013-10-08 15:31:03 | Is there a Maximum number of partitions in which constraint_exclusion works? |