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

Todo:

1. Compact log files after checkpoint (save records of uncommitted
   transactions and remove/archive others).
2. Abort long running transactions.

Vadim

Mon, 21 May 2001 13:29:03 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: AW: Plans for solving the VACUUM problem