----- "Tatsuo Ishii" <[EMAIL PROTECTED]> escribió: > > pgpool-II won't do load balance when there are select and > insert/update/delete statements in the same transaction. Instead, it > will execute all queries against the master node and the > insert/update/delete ones against the slave node only. > > No. When a client connects to pgpool-II, pgpool-II will select > randomly one of the nodes for load balance. If the client start a > transaction, pgpool-II sends "BEGIN" to all nodes. and if the client > sends some DML, it will sends to all nodes as well. If the client > then > sends "load-balance possible"(see the attached diagram) SELECT, it > will be sent to the node which pgpool-II chooses at the connection > time.
I had understood from the documentation that it would always be the master node. Thanks for the clarification, Tatsuo. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
