Re: [HACKERS] wait events for disk I/O

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] wait events for disk I/O
Дата
Msg-id CA+Tgmoax0RWf_fSOxOmbL01eH0Rp7i0sXjtCNDr0hu-_QvAOEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] wait events for disk I/O  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: [HACKERS] wait events for disk I/O
Список pgsql-hackers
On Mon, Mar 6, 2017 at 9:09 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Sure, if you think both Writes and Reads at OS level can have some
> chance of blocking in obscure cases, then we should add a wait event
> for them.

I think writes have a chance of blocking in cases even in cases that
are not very obscure at all.

>> I think somebody should try a pgbench run with this patch applied,
>> using a scale factor greater than shared_buffers, and generate a wait
>> event profile, just to see if these are showing up and how often.
>
> Yeah, that makes sense to me and we should try for both read-write and
> read-only tests.

wfm.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: [HACKERS] ALTER PUBLICATION and segmentation fault
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] WIP: Faster Expression Processing v4