Re: WALWriteLock contention

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WALWriteLock contention
Дата
Msg-id 4841.1431709743@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WALWriteLock contention  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: WALWriteLock contention  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> WALWriteLock contention is measurable on some workloads.  In studying
> the problem briefly, a couple of questions emerged:

> 1. Doesn't it suck to rewrite an entire 8kB block every time, instead
> of only the new bytes (and maybe a few bytes following that to spoil
> any old data that might be there)?

It does, but it's not clear how to avoid torn-write conditions without
that.

> 2. I don't really understand why WALWriteLock is set up to prohibit
> two backends from flushing WAL at the same time.  That seems
> unnecessary.

Hm, perhaps so.
        regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Changes to backup.sgml
Следующее
От: Volker Aßmann
Дата:
Сообщение: Re: Disabling trust/ident authentication configure option