Re: triggers on prepare, commit, rollback... ? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: triggers on prepare, commit, rollback... ?
Date
Msg-id 1211284258.8174.48.camel@huvostro
Whole thread Raw
In response to Re: triggers on prepare, commit, rollback... ?  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: triggers on prepare, commit, rollback... ?
Next
From: "Florian G. Pflug"
Date:
Subject: Re: triggers on prepare, commit, rollback... ?