Re: Pgbouncer pool_mode and application behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Jun 13, 2022, at 8:04 AM, Kristjan Mustkivi <sonicmonkey@xxxxxxxxx> wrote:
> 
> Am I correct to guess, that pgbouncer in this case in
> pool_mode=session does not help at all and in order to improve
> throughput, server engineers really must implement support for
> transaction mode that pgbouncer provides?

You are correct that session mode will not solve the problem you described. There are 3 possibilities:

- as you mentioned, changed clients to be compatible with pgbouncer transaction pooling

- increase pg max_connections

- increase timeouts, use retries, etc so that the servers are more resilient to being temporarily denied connections





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux