Skip site navigation (1) Skip section navigation (2)

Re: ice-broker scan thread

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ice-broker scan thread
Date: 2005-11-29 05:25:17
Message-ID: Pine.LNX.4.58.0511291616390.18662@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 28 Nov 2005, Qingqing Zhou wrote:

>
>
> On Mon, 28 Nov 2005, Gavin Sherry wrote:
> >
> > MySQL, Oracle and others implement read-ahead threads to simulate async IO
> > 'pre-fetching'.
>
> Due to my tests on Windows (using the attached program and change
> enable_aio=true), seems aio doesn't help as a separate thread - but maybe
> because my usage is wrong ...

Right, I would imagine that it's very close. I intend to use kernel based
async IO so that we can have the prefetch effect of your sample program
without the need for threads.

Thanks,

Gavin

In response to

pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2005-11-29 05:55:36
Subject: Re: ice-broker scan thread
Previous:From: David BorehamDate: 2005-11-29 05:20:59
Subject: Re: ice-broker scan thread

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group