[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