Markus Bertheau <[EMAIL PROTECTED]> writes:
> How does oracle do that? Has all this something to do with mvcc? Why
> does it take oracle so long to recover?
Postgres does "pessimistic MVCC" where it keeps the old versions where they
are in the table. Only after it's committed can they be cleaned
Markus Bertheau <[EMAIL PROTECTED]> writes:
> Now if you pull the plug after 2, at startup, pg will go through the
> in-progress txns and mark them as aborted. That's all the recovery in
> this case. All rows are still there. O(1).
Right. (Actually it's O(checkpoint interval), because we have to
Hi.
Our professor told us the following story: Oracle. A client issued a
selective delete statement on a big table. After two days he lost
patience and pulled the plug. Unfortunately while starting up, oracle
had to restore all the deleted rows, which took it another two days. He
reasoned that one