[pgpool-general: 6347] Re: question regarding pgpool effiecncy in my case

[Bo Peng]

Hi,

On Sun, 9 Dec 2018 15:00:33 +0200
Mariel Cherkassky <mariel.cherkassky at gmail.com> wrote:

> Hi,
> I'm trying to implement pgpool2 in our environment but in our performance
> tests it seems that when we use pgpool the performance are worse.
> Therefore, I wanted to check if pgpool is the right solution based on the
> next info that I read :
> " process opens a new backend connection only if the requested
> [user,database] pair is not already in the cache. So if the application
> uses only one user to connect to only one database, say [pguser1,pgdb1],
> then each child will continue to reuse the first connection and will never
> open a second connection, so in effect pgpool will open no more than 100
> backend connections even though max_pool is set to 3."
> 
> In my case, I have 3 databases and for every database I have a dedicated
> user. The application access each of those databases with a dedicated user.
> Now basicaly, if my max_connections is set to 500, pgpool max_pool set to 3
> and the num_of_init_children is set to 100 it means that at every moment I
> can have at most 100 sessions to each one of the  databases (with pgpool..).

If you set 
  max_pool = 3
  num_init_children = 100

you can have most 300 sessions to backend servers.


> Thanks , Mariel.


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan