On Tue, 2008-05-20 at 13:36 +0200, Fabien COELHO wrote: > > or running data modifications through pl/proxy functions where > > partitioning function always returns two partitions > > I don't think that pl/proxy takes care of 2PC semantics in any useful way. > > Possibly something like pgpool could take care somehow of the replication > by executing queries on two backends, but there are issues with such an > approach (say, a SEQUENCE may not return the same result on both sides, > some functions may have side effects...), and on commit it must use > prepared statements on both sides, and I don't think this is the case > for now with the current pgpool. > > Anyway, I do not think that there is a simple high availability / high > throuput / low latency / guaranteed replication / easy to administrate / > load balanced silver bullet... My point is more about exploration, and > for that user-visible hooks would help.
2PC will never be any of ( high throuput / low latency / easy to administrate ) ------------- Hannu -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers