Re: [HACKERS] wait events for disk I/O - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] wait events for disk I/O
Date
Msg-id CA+Tgmoax0RWf_fSOxOmbL01eH0Rp7i0sXjtCNDr0hu-_QvAOEw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] wait events for disk I/O  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] wait events for disk I/O  (Amit Kapila <amit.kapila16@gmail.com>)
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: [HACKERS] ALTER PUBLICATION and segmentation fault
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] WIP: Faster Expression Processing v4