RE: WAL versus Postgres (or: what goes around, comes ar ound)

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: WAL versus Postgres (or: what goes around, comes ar ound)
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A23018BDB@SECTORBASE1
обсуждение исходный текст
Список pgsql-hackers
> > I've read this paper ~2 years ago. My plans so far were:
> > 
> > 1. WAL in 7.1
> > 2. New (overwriting) storage manager in 7.2
> > 
> 
> Oh, so Vadim has overwriting storage manager concept for 7.2.
> Vadim, how will you keep old rows around for MVCC?

Just like you told about it - some outstanding files for old
versions. Something like Oracle' rollback segments.
And, for sure, this will be the most complex part of smgr and
that's why I think that we can't use their smgr if we're
going to keep MVCC.

As for WAL, WAL itself (as collection of routines to log changes,
create checkpoints etc) is 90% done. Now it has to be integrated
into system and the most hard part of this work are access methods
specific redo/undo functions. If we're going to use our access
methods then we'll have to write these functions for no matter
what WAL implementation will be used.

Vadim


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Proposal: replace no-overwrite with Berkeley DB
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Proposal: replace no-overwrite with Berkeley DB