Re: Advice/guideline on increasing shared_buffers and kernel parameters

"Gnanakumar" <gnanam@zoniac.com> wrote:

> our web-based application has crossed more than 500 concurrent
> users.  Hence we've already upgraded RAM and now we want to
> upgrade max connection parameter too.  Yes, we're already using
> pgpool-II v3.1.1 for connection pooling.

The main point of using a connection pooler is to funnel a large
number of client connection into the pooler into a small number of
database connections.  We get very good performance dealing with
thousands of concurrent users with a pool of 35 connections to the
database.  We originally had a larger pool, but contention was
reducing performance, and we found that throughput and latency both
improved with a smaller pool of database connections.

If you want to handle more users than you can currently support, you
probably need to use fewer database connections.

-Kevin