Re: Overhauling GUCS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Overhauling GUCS
Дата
Msg-id 11913.1213218315@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Overhauling GUCS  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Overhauling GUCS
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Josh Berkus wrote:
>> Ideally, of course, there would be no wal_buffers setting, and WAL  
>> buffers would be allocated from shared_buffers pool on demand...

> Same for pg_subtrans, pg_clog, etc (as previously discussed)

I agree with that for pg_clog and friends, but I'm much more leery of
folding WAL into the same framework.  Its access pattern is *totally*
unlike standard caches, so the argument that this would be good for
performance is resting on nothing but imagination.  Also I'm concerned
about possible deadlocks, because WAL is customarily accessed while
holding one or more exclusive buffer locks.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Overhauling GUCS
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: How to Sponsor a Feature