Jim Nasby wrote:
> 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.
Yes, I have heard that Continuent/Sequoia has a process running on each
server that deals with many of the problems with broadcasting. Not sure
how I should work that into the documentation. In fact, based on our
description, the improvements Continuent/Sequoia made are probably
clearer.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +