Tom Lane wrote:
Heikki Linnakangas <[EMAIL PROTECTED]> writes:
As a proposed fix, instead of acquiring the CheckpointStartLock in
RecordTransactionCommit, we set a flag in MyProc saying "commit in
progress". Checkpoint will scan through the procarray and make note of
any commit in progress transactions, after computing the new redo record
ptr, and wait for all of them to finish before flushing clog.
What sort of "wait for finish" mechanism do you have in mind? While
I've always thought CheckpointStartLock is a pretty ugly solution,
I'm not sure the above is better.
I was thinking of XactLockTableWait.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster