pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedlimit connections pgpool
3+ messages / 3 participants
[nested] [flat]
* limit connections pgpool
@ 2013-10-10 15:00 Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
0 siblings, 2 replies; 3+ messages in thread
From: Jeison Bedoya Delgado @ 2013-10-10 15:00 UTC (permalink / raw)
To: 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: limit connections pgpool
@ 2013-10-11 03:10 Michael Paquier <michael.paquier@gmail.com>
parent: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2013-10-11 03:10 UTC (permalink / raw)
To: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>; +Cc: pgsql-performance
On Fri, Oct 11, 2013 at 12:00 AM, Jeison Bedoya Delgado
<jeisonb@audifarma.com.co> wrote:
> 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.
You should ask that directly to the pgpool mailing lists:
http://www.pgpool.net/mediawiki/index.php/Mailing_lists
Regards,
--
Michael
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: limit connections pgpool
@ 2013-10-11 03:38 Tatsuo Ishii <ishii@postgresql.org>
parent: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
1 sibling, 0 replies; 3+ messages in thread
From: Tatsuo Ishii @ 2013-10-11 03:38 UTC (permalink / raw)
To: jeisonb@audifarma.com.co; +Cc: 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.
That's the result of connection cache functionality of pgpool-II. If
you don't need the connection cache of pgpool-II at all, you could
turn it off:
connection_cache = off
Or you could set following to non 0.
connection_life_time
After an idle connection to PostgreSQL backend lasts for
connection_life_time seconds, the connection will be turned off.
If you have further questions, you'd better to subscribe and post the
question:
http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-10-11 03:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-10-10 15:00 limit connections pgpool Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
2013-10-11 03:10 ` Michael Paquier <michael.paquier@gmail.com>
2013-10-11 03:38 ` Tatsuo Ishii <ishii@postgresql.org>
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