limit connections pgpool

Поиск
Список
Период
Сортировка
От Jeison Bedoya Delgado
Тема limit connections pgpool
Дата
Msg-id 5256C123.1030103@audifarma.com.co
обсуждение исходный текст
Ответы Re: limit connections pgpool  (Michael Paquier <michael.paquier@gmail.com>)
Re: limit connections pgpool  (Tatsuo Ishii <ishii@postgresql.org>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Marcelo Vega
Дата:
Сообщение: Is there a Maximum number of partitions in which constraint_exclusion works?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?