
> Correct me if I am wrong, but both cases do present a problem currently 
> in 7.1.  The WAL log will not remove any WAL files for transactions that 
> are still open (even after a checkpoint occurs).  Thus if you do a bulk 
> insert of gigabyte size you will require a gigabyte sized WAL 
> directory.  Also if you have a simple OLTP transaction that the user 
> started and walked away from for his one week vacation, then no WAL log 
> files can be deleted until that user returns from his vacation and ends 
> his transaction.

I am not sure, it might be so implemented. But there is no technical reason
to keep them beyond checkpoint without UNDO.

Andreas

Tue, 22 May 2001 09:54:21 +0200
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: AW: Plans for solving the VACUUM problem