Horton
Menu

Re: [SPAM?] Re: Asynchronous I/O Support

Mark Mielke <mark@mark.mielke.cc>

View thread
From: mark@mark.mielke.cc
To: Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>
Cc: NikhilS <nikkhils@gmail.com>, Martijn van Oosterhout <kleptog@svana.org>, Mark Kirkwood <markir@paradise.net.nz>, Luke Lonergan <llonergan@greenplum.com>, Raja Agrawal <raja.agrawal@gmail.com>, pgsql-hackers@postgresql.org
Date: 2006-10-20T17:11:16Z
Lists: pgsql-hackers 
On Fri, Oct 20, 2006 at 05:37:48PM +0200, Zeugswetter Andreas ADI SD wrote:
> Yup, that would be the scenario where it helps (provided that you have
> a smart disk or a disk array and an intelligent OS aio implementation).
> It would be used to fetch the data pages pointed at from an index leaf,
> or the next level index pages.
> We measured the IO bandwidth difference on Windows with EMC as beeing 
> nearly proportional to parallel outstanding requests up to at least

Measured it using what? I was under the impression only one
proof-of-implementation existed, and that the scenarios and
configuration of the person who wrote it, did not show significant
improvement.

You have PostgreSQL on Windows with EMC with async I/O support to
test with?

Cheers,
mark

-- 
mark@mielke.cc / markm@ncf.ca / markm@nortel.com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada

  One ring to rule them all, one ring to find them, one ring to bring them all
                       and in the darkness bind them...

                           http://mark.mielke.cc/