Re: Is there a peer-to-peer server solution with PG? - Mailing list pgsql-general

From Christopher Browne
Subject Re: Is there a peer-to-peer server solution with PG?
Date
Msg-id 60vf94pehh.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Re: Is there a peer-to-peer server solution with PG?  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
jg@rilk.com (Pailloncy Jean-Gerard) writes:
> I suppose (because I never used it) that there is a speed boost.

I would suppose (because synchronization has substantial costs) that
there is more than likely _no_ material improvement in performance.

"Clustering" can only provide material performance improvements if the
problem turns out to be "embarrassingly parallelizable."  That is a
rather difficult condition to satisfy, and it is very likely to be
FALSE whenever there is need for conflict resolution between nodes.
--
"cbbrowne","@","ca.afilias.info"
<http://linuxdatabases.info/info/slony.html>
Christopher Browne
(416) 673-4124 (land)

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Problem performing a restore of a data schema in Windows
Next
From: Clodoaldo Pinto
Date:
Subject: Out of memory error