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

Tatsuo Ishii ishii at sraoss.co.jp
Thu Aug 13 08:39:40 UTC 2009


> > So, if there are 3 backends (0, 1, and 2), the order will be:
> > 1. Execute in the last backend (backend 2)
> > 2. Wait for execution.
> > 3. If okay, execute (paralelly) in the rest of backends (in this case in backend 0 and 1)
> > 4. If okay, return okay to client.
> 
> I think it's first in the master, then in all slaves, but you are
> making me doubt right now... Tatsuo will know.

If the command is not commit/abort etc:

1. Wait for execution in backend 0
2. If okay, execute (paralelly) in the rest of backends (in this case in backend 1 and 2)

If the command is not commit/abort etc:

1. Execute (paralelly) in the rest of backends (in this case in backend 1 and 2)
2. If okay, execute in backend 0
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list