pgpool-II (max_pool and num_init_children)

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: pgpool-II (max_pool and num_init_children)
Date: 2010-07-02 11:36:59
Message-ID: 4C2DCF5B.3080602@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to get a handle on sane values for these two parameters. I
assume that they should somehow correlate to my existing
max_connections in my postgresql.conf file. Anyone using pgpool-II care
to comment?

I'm sure it's a balancing act between how many connections you want
verses how many cached connections you have, but not sure how to
properly assess this issue.

(I've tried posting to the pgpool list, but it's apparently unavailable
at this time)

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Landscheidt 2010-07-02 11:56:02 Re: Query to "balance" rows across multiple tables
Previous Message Pavel Stehule 2010-07-02 10:52:44 Re: bulk insert using COPY and PHP code