AW: AW: Plans for solving the VACUUM problem - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: Plans for solving the VACUUM problem
Date
Msg-id 11C1E6749A55D411A9670001FA6879633682E9@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> Todo:
> 
> 1. Compact log files after checkpoint (save records of uncommitted
>    transactions and remove/archive others).

On the grounds that undo is not guaranteed anyway (concurrent heap access),
why not simply forget it, since above sounds rather expensive ?
The downside would only be, that long running txn's cannot [easily] rollback
to savepoint.

> 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.

Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Plans for solving the VACUUM problem
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: PL/pgSQL CURSOR support