Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node - Mailing list pgsql-hackers

From Trevor Talbot
Subject Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Date
Msg-id 90bce5730712172229u24e1fb2cg2cc71e226cd79aac@mail.gmail.com
Whole thread Raw
In response to Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
On 12/17/07, Decibel! <decibel@decibel.org> wrote:

> Also, has anyone looked into adding a class of system calls that
> would actually tell us if the kernel issued physical IO? I find it
> hard to believe that other RDBMSes wouldn't like to have that info...

Non-blocking style interfaces can help here. On Windows, for instance,
a read returns data at the call site if it was satisfied by cache,
instead of invoking the asynchronous notification.


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Next
From: Dimitri Fontaine
Date:
Subject: Re: Sorting Improvements for 8.4