Re: Storage Manager (was postgres 7.2 features.)

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: Storage Manager (was postgres 7.2 features.)
Дата
Msg-id 396AC746.2E8A0A86@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на RE: postgres 7.2 features.  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Ответы Re: Storage Manager (was postgres 7.2 features.)  (JanWieck@t-online.de (Jan Wieck))
Список 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: Patch for pg_dump
Следующее
От: "Adam Walczykiewicz"
Дата:
Сообщение: SQL-92 SQLSTATE in PostgreSQL ?!