On Nov 14, 2006, at 5:11 PM, Bruce Momjian wrote:
Basically, when you are broadcasting outside the server, you are
broadcasting SQL queries, and those queries do not have information
about non-deterministic functions and have issues with universal
commits
on all node.
That's true of simple query broadcasting (ie: pgpool), but not true
of Continuent/Sequoia. Continuent's software adds a lot of additional
features on top of simple query broadcasting, making it far more
robust than simply spewing queries out to every node in the cluster.
You still have to be very careful with how you use it, but not nearly
as much as with simpler solutions.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
