Postgres Pro
Downloads
Home   >   mailing lists

limit connections pgpool - Mailing list pgsql-performance

From Jeison Bedoya Delgado
Subject limit connections pgpool
Date
Msg-id 5256C123.1030103@audifarma.com.co
Whole thread Raw
Responses Re: limit connections pgpool  (Michael Paquier <michael.paquier@gmail.com>)
Re: limit connections pgpool  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Marcelo Vega
Date:
Subject: Is there a Maximum number of partitions in which constraint_exclusion works?
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?