Re: Fix overflow of bgwriter's request queue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fix overflow of bgwriter's request queue
Дата
Msg-id 10731.1137714338@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Fix overflow of bgwriter's request queue  (ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>)
Ответы Re: Fix overflow of bgwriter's request queue
Список pgsql-patches
ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp> writes:
> Attached is a revised patch. It became very simple, but I worry that
> one magic number (BUFFERS_PER_ABSORB) is still left.

Have you checked that this version of the patch fixes the problem you
saw originally?  Does the problem come back if you change
BUFFERS_PER_ABSORB to too large a value?  If you can identify a
threshold where the problem reappears in your test case, that would help
us choose the right value to use.

I suspect it'd probably be sufficient to absorb requests every few times
through the fsync loop, too, if you want to experiment with that.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] pgxs/windows
Следующее
От: "Rocco Altier"
Дата:
Сообщение: Re: [HACKERS] pgxs/windows