> On third thought --- we could still log the original page contents and
> the modification log record atomically, if what were logged in the xlog
> record were (essentially) the parameters to the operation being logged,
> not its results. That is, make the log entry before you start doing the
> mod work, not after. This might also simplify redo, since redo would be
> no different from the normal case. I'm not sure why Vadim didn't choose
> to do it that way; maybe there's some other fine point I'm missing.

There is one - indices over user defined data types: catalog is not
available at the time of recovery, so, eg, we can't know how to order
keys of "non-standard" types. (This is also why we have to recover
aborted index split ops at runtime, when catalog is already available.)

Also, there is no point why should we log original page content and
the next modification record separately.

Vadim



Wed, 7 Mar 2001 03:45:52 -0800
"Vadim Mikheev" <vmikheev@sectorbase.com>
Re: WAL-based allocation of XIDs is insecure 