Re: [HACKERS] proposals for LLL, part 1 - Mailing list pgsql-hackers

From Dr. Michael Meskes
Subject Re: [HACKERS] proposals for LLL, part 1
Date
Msg-id 19980727165407.A2473@feivel.online-club.de
Whole thread Raw
In response to Re: [HACKERS] proposals for LLL, part 1  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-hackers
On Fri, Jul 17, 1998 at 01:00:10PM +0800, Vadim Mikheev wrote:
> In original postgres there was dedicated vacuum process...
> Vacuuming without human administration is possible but
> in any case commit in non-overwriting system requires
> ~2 data block writes (first - to write changes, second - to
> write updated xmin/xmax statuses). In WAL systems only
> 1 data block write required...

Then the arguments are clearly in favor of WAL.

> Oracle is WAL and multi-version system!

While Oracle has some faults (or more) I agree with that choice.

> We could implement multi-version control now and switch
> to WAL latter...

Once again I fully agree.

> I personally very like multi-versions...

Me too.

Michael
--
Dr. Michael Meskes        meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!

pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] OR clause issues
Next
From: "Dr. Michael Meskes"
Date:
Subject: Re: [HACKERS] Q about read committed in Oracle...