On Tue, 14 Nov 2006, Bruce Momjian wrote:
In clustering, each server can accept write requests, and these write requests
are broadcast from the original server to all other servers before each
transaction commits.
I guess it's kind of a fine line how it gets defined?
Hmmm. Interesting. Does anyone else have details or an opinion on
this? The fact that there is something sitting above the servers seems
to be the defining issue of calling it query broadcast.
My thinking on the definition of clustering was that there is some smarts for
graceful failover and automated or semi-automated ways of bringing failed DB
servers back up to date and online with the rest of the servers in the
cluster. All servers need to be able to accept writes, but do we
differentiate on where the writes originated (i.e. middleware or another
postgresql server) or on functionality?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
