[Pgpool-general] Order of execution of queries by pgpool

[Tatsuo Ishii]

> When inserting, updating or deleting through pgpool connected to two
> backends, is the order of commits:
> 
>  
> 
> 1.    Backend 0, and then Backend 1?

Actually Backend 1, and then Backend 0.

> 2.    "at the same time" (in two independent threads) and waits for both
> to be successful in order to return a successful transaction to the
> client?
> 
>  
> 
> If the answer is 1, why not 2?

To avoid "global" deadlock. If there's only one session, global
deadlock will never occur and we could do as you suggested. This will
be a nice optimization but we do not do so currently.
--
Tatsuo Ishii
SRA OSS, Inc. Japan