Re: literature on write-ahead logging

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: literature on write-ahead logging
Дата
Msg-id BANLkTi=SuaiXtBrm93cYmAjLEjLG7CsT=Q@mail.gmail.com
обсуждение исходный текст
Ответ на literature on write-ahead logging  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Jun 8, 2011 at 11:24 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> I did a brief literature search for papers on breaking the
> WAL-serialization bottleneck today and hit upon this:
>
> Aether: A Scalable Approach to Logging, Ryan Johnson, Ippokratis Pandis, et al.
> http://infoscience.epfl.ch/record/149436/files/vldb10aether.pdf
>
> Section 5 appears to be the most relevant to our problems with WALInsertLock.
>
> They reject the approach that I proposed, wherein WAL is generated by
> individual backends in their own queues and serialized later: "While a
> total ordering is not technically required for correctness, valid
> partial orders tend to be too complex and interdependent to be worth
> pursuing as a performance optimization"; see also appendix A.5, which
> may be succinctly summarized as "no one does that".

heh -- makes total sense.  great stuff.

merlin


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

Предыдущее
От: Jeevan Chalke
Дата:
Сообщение: Re: Invalid byte sequence for encoding "UTF8", caused due to non wide-char-aware downcase_truncate_identifier() function on WINDOWS
Следующее
От: Brar Piening
Дата:
Сообщение: Re: smallserial / serial2