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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings