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

[Bo Peng]

Hi,

On Wed, 19 Dec 2018 14:45:22 +0200
Mariel Cherkassky <mariel.cherkassky at gmail.com> wrote:

> A child cant have 3 connections to the same database with the same user
> right ? In other words, If I have only one database and one user I should
> set max_pool to 1 ?

Sorry for late response.
Yes, if you have only one database and one user, you should set "max_pool = 1".


> ‫בתאריך יום ו׳, 14 בדצמ׳ 2018 ב-1:29 מאת ‪Bo Peng‬‏ <‪pengbo at sraoss.co.jp
> ‬‏>:‬
> 
> > 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
> >
> >


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