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 | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
