Andrew Sullivan ajs
Thu Jul 20 14:06:11 PDT 2006
On Tue, Jul 11, 2006 at 05:13:14PM -0400, Christopher Browne wrote:
> One wild-eyed idea came up in the discussions of the last week...
> 
> Is it possible that there might be some small value to the notion of
> running certain operations via 2PC?

What worries me about this is the way the locking will work.  Won't
this cause some rather nasty locks on all the nodes for (e.g.) DDL? 
ALTER TABLE takes an ACCESS EXCLUSIVE lock according to the
documents.  AFAIK, that lock has to be maintained until COMMIT, and
across node crashes.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler



More information about the Slony1-general mailing list