On 12-05-2016 13:09, Bruce Momjian wrote:
> That is an interesting approach. How many applications are prepared to
> re-sent a transaction block based on the error returned by pgbouncer in
> this case?
>
FYI, pgBouncer does not error out transactions. While in PAUSE mode,
pgBouncer waits for the current transactions to finish and the new ones
are put in a wait queue. After the RESUME command, pgBouncer sends the
transaction in the wait queue. Of course, if your application has a
response timeout you will see cancellations.
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento