From: | Jehan-Guillaume de Rorthais <ioguix(at)free(dot)fr> |
---|---|
To: | alexanderfelipewo <alexanderfelipewo(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgbouncer increase pool_size, reload does not work |
Date: | 2017-02-02 23:17:46 |
Message-ID: | 20170203001746.2a6b37cf@firost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 2 Feb 2017 04:27:45 -0700 (MST)
alexanderfelipewo <alexanderfelipewo(at)gmail(dot)com> wrote:
> hello!
>
> i have a question for pgbouncer in case someone has faced this and there is
> a solution available.
>
> i have a db with pgbouncer where the pool_size is set to 50 (i ve noticed
> this using both session/transaction modes). Sometimes there are waiting
> sessions b/c more than 50 want to execute sth at once and usually each query
> is not so fast. So let's say i want to increase the pool_size from 50 to 70.
> I change the config file and then login to pgbouncer where i run a
> 'reload;'. Now when i check the 'show config' i see the new value in the
> 'default_pool_size' parameter.
>
> BUT
>
> the problem is that the amount of servers is still 50 and does not go up to
> 70. At the same time there are clients in a 'waiting' state. If i do a
> restart then it will work and the servers will be able to go up to 70.
>
> I ve tried these in different databases and it doesnt happen all the time
> but it does happen pretty often.
> Has anyone else seen this? if so, is there a solution (except restarting) or
> explanation?
That's because internally, it seems each pool (pair of role/db) is set up when
it is created, eg. during the very first connexion.
Even if the default pool_size can be changed with a simple reload,
you will have to wait for your pool to be fully deallocated before it
can be recreated with the new pool_size value.
I didn't dig too much in the code, maybe a core hacker of pgbouncer can provide
some better details and tips about this.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-02-03 00:12:06 | Re: pgbouncer increase pool_size, reload does not work |
Previous Message | John R Pierce | 2017-02-02 22:18:18 | Re: [SPAM] AD(Active Directory) groups concepts in postgres |