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

Jaume Sabater jsabater at gmail.com
Wed Aug 12 16:14:07 UTC 2009


On Wed, Aug 12, 2009 at 4:00 PM, <Daniel.Crespo at l-3com.com> wrote:

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

1. Execute in backend 1
2. Wait for execution.
3. If okay, execute (paralelly, I believe) in the rest of backends (in
this case only in backend 0).
4. If okay, return okay to client.

Correct, Tatsuo?

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"


More information about the Pgpool-general mailing list