| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Jeff Frost <jeff(at)frostconsultingllc(dot)com>, Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Replication documentation addition |
| Date: | 2006-11-17 01:48:58 |
| Message-ID: | EE16DB51-3C5E-4A18-BA5E-E7EB60853194@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
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 jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2006-11-18 23:29:07 | Re: [HACKERS] Replication documentation addition |
| Previous Message | Richard Broersma Jr | 2006-11-16 06:36:01 | Re: Valued Predicates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2006-11-17 03:48:49 | Re: Cast null to int4 upgrading from Version 7.2 |
| Previous Message | Jim Nasby | 2006-11-17 01:29:35 | ALTER TABLE RENAME column |