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

Re: ice-broker scan thread

From: David Boreham <david_list(at)boreham(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ice-broker scan thread
Date: 2005-11-29 04:34:26
Message-ID: 438BDA52.7090601@boreham.org (view raw or flat)
Thread:
Lists: pgsql-hackers
>
>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.
>  
>
...<reads paper>... ok, interesting. Did they say that Oracle isn't 
using aio ?
I can't see that. They that Oracle has no more than one outstanding I/O
operation in flight per concurrent query,
and they appear to think that's a bad thing. I'm not seeing
that myself. Perhaps once I sleep on it, it'll become clear what they're 
getting at.

One theory for lack of aio in Oracle as tested in that paper would be 
that they
were testing on Linux. Since aio is relatively new in Linux I wouldn't 
be surprised
if Oracle didn't actually use it until it's known to be widely deployed 
in the field
and to have proven reliability. Perhaps we've reached that state around now,
and so Oracle may not yet have released an aio-capable Linux version of 
their
RDBMS. Just a theory...someone from those tubular towers lurking here
could tell us for sure I guess...




In response to

pgsql-hackers by date

Next:From: Gavin SherryDate: 2005-11-29 04:38:39
Subject: Re: ice-broker scan thread
Previous:From: Mark KirkwoodDate: 2005-11-29 04:19:50
Subject: Re: ice-broker scan thread

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