From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
---|---|
To: | "Mike Mascari" <mascarm(at)mascari(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Andrew Sullivan" <andrew(at)libertyrms(dot)info>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 2-phase commit |
Date: | 2003-10-10 11:11:23 |
Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA4962036@m0114.s-mxs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I was wondering whether we need to keep WAL online for 2PC,
or whether only something like clog is sufficient.
What if:
1. phase 1 commit must pass the slave xid that will be used for 2nd phase
(it needs to return some sort of identification anyway)
2. the coordinator must keep a list of slave xid's along with
corresponding (commit/rollback) info
Is that not sufficient ? Why would WAL be needed in the first place ?
This is not replication, the slave has it's own WAL anyway.
I also don't buy the argument with the lockup. Iff today somebody connects
with psql starts a transaction modifies something and then never commits
or aborts there is also no automatism builtin that will eventually kill
it automatically. 2PC will simply need to have means for the administrator
to rollback/commit an in doubt transaction manually.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-10-10 11:50:06 | Re: [HACKERS] initdb |
Previous Message | Curt Sampson | 2003-10-10 10:08:44 | Broken Constraint Checking in Functions |