From: Gavin Sherry <swm@linuxworld.com.au>
To: David Boreham <david_list@boreham.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: ice-broker scan thread
Date: Tue, 29 Nov 2005 15:14:38 +1100 (EST)
Message-ID: <Pine.LNX.4.58.0511291513260.18370@linuxworld.com.au> (raw)
In-Reply-To: <438BD493.3070507@boreham.org>
References: <Pine.LNX.4.58.0511282217470.13586@josh.db>
<Pine.LNX.4.58.0511291429330.18112@linuxworld.com.au>
<438BD493.3070507@boreham.org>
On Mon, 28 Nov 2005, David Boreham wrote:
> Gavin Sherry wrote:
>
> > MySQL, Oracle and others implement read-ahead threads to simulate async IO
>
> I always believed that Oracle used async file I/O. Not that I've seen their
> code, but I'm fairly sure they funded the addition of kernel aio to Linux
> a few years back.
That's right.
>
> But....Oracle comes from a time long ago when threads and decent
> filesystems didn't exist, so some of the things they do may not be
> appropriate
> to add to a product that doesn't have them today.
The paper I linked to seemed to suggest that they weren't using async IO
in 9.2 -- which is fairly old. I'm not sure why the authors didn't test
10g.
Gavin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: swm@linuxworld.com.au, david_list@boreham.org
Subject: Re: ice-broker scan thread
In-Reply-To: <Pine.LNX.4.58.0511291513260.18370@linuxworld.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox