> > The downside would only be, that long running txn's cannot
> > [easily] rollback to savepoint.
> We should implement savepoints for all or none transactions, no?
We should not limit transaction size to online available disk space for WAL.
Imho that is much more important. With guaranteed undo we would need
diskspace for more than 2x new data size (+ at least space for 1x all modified
pages unless physical log is separated from WAL).
Imho a good design should involve only little more than 1x new data size.
> > > 2. Abort long running transactions.
> > This is imho "the" big downside of UNDO, and should not
> > simply be put on the TODO without thorow research. I think it
> > would be better to forget UNDO for long running transactions
> > before aborting them.
> Abort could be configurable.
The point is, that you need to abort before WAL runs out of disk space
regardless of configuration.
pgsql-hackers by date
|Next:||From: Philip Warner||Date: 2001-05-23 08:58:58|
|Subject: RE: Plans for solving the VACUUM problem|
|Previous:||From: Zeugswetter Andreas SB||Date: 2001-05-23 08:26:26|
|Subject: AW: Plans for solving the VACUUM problem|