Horton
Menu

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

Merlin Moncure <mmoncure@gmail.com>

View thread
From: "Merlin Moncure" <mmoncure@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Martijn van Oosterhout" <kleptog@svana.org>, mark@mark.mielke.cc, NikhilS <nikkhils@gmail.com>, "Mark Kirkwood" <markir@paradise.net.nz>, "Luke Lonergan" <llonergan@greenplum.com>, "Raja Agrawal" <raja.agrawal@gmail.com>, pgsql-hackers@postgresql.org
Date: 2006-10-20T19:04:55Z
Lists: pgsql-hackers 
On 10/20/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So far I've seen no evidence that async I/O would help us, only a lot
> of wishful thinking.

is this thread moot?  while researching this thread I came across this
article: http://kerneltrap.org/node/6642 describing claims of 30%
performance boost when using posix_fadvise to ask the o/s to prefetch
data.  istm that this kind of improvement is in line with what aio can
provide, and posix_fadvise is cleaner, not requiring threads and such.

merlin