Re: Storage Manager (was postgres 7.2 features.)

From: Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: pgsql-hackers(at)hub(dot)org
Subject: Re: Storage Manager (was postgres 7.2 features.)
Date: 2000-07-11 07:05:42
Message-ID: 396AC746.2E8A0A86@nimrod.itg.telecom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Has sufficient research been done to warrant destruction of what is
currently there?

According to the postgres research papers, the no-overwrite storage
manager has the following attributes...

* It's always faster than WAL in the presence of stable main memory.
(Whether the stable caches in modern disk drives is an approximation I
don't know).

* It's more scalable and has less logging contention. This allows
greater scalablility in the presence of multiple processors.

* Instantaneous crash recovery.

* Time travel is available at no cost.

* Easier to code and prove correctness. (I used to work for a database
company that implemented WAL, and it took them a large number of years
before they supposedly corrected every bug and crash condition on
recovery).

* Ability to keep archival records on an archival medium.

Is there any research on the level of what was done previously to
warrant abandoning these benefits? Obviously WAL has its own benefits, I
just don't want to see the current benefits lost.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Adam Walczykiewicz 2000-07-11 07:15:12 SQL-92 SQLSTATE in PostgreSQL ?!
Previous Message Philip Warner 2000-07-11 06:37:13 Re: postgres 7.2 features.