X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E636F9DCAB3 for ; Tue, 29 Nov 2005 00:45:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07270-05 for ; Tue, 29 Nov 2005 00:45:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [203.96.152.180]) by postgresql.org (Postfix) with ESMTP id 087339DCAB2 for ; Tue, 29 Nov 2005 00:45:20 -0400 (AST) Received: from smtp-3.paradise.net.nz (tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IQP00GKH97J4Q@linda-1.paradise.net.nz> for pgsql-hackers@postgresql.org; Tue, 29 Nov 2005 17:45:19 +1300 (NZDT) Received: from [192.168.1.11] (218-101-29-74.dsl.clear.net.nz [218.101.29.74]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id EFD942D170B; Tue, 29 Nov 2005 17:45:18 +1300 (NZDT) Date: Tue, 29 Nov 2005 17:45:17 +1300 From: Mark Kirkwood Subject: Re: ice-broker scan thread In-reply-to: To: Gavin Sherry Cc: David Boreham , pgsql-hackers@postgresql.org Message-id: <438BDCDD.40600@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106) References: <438BD493.3070507@boreham.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.158 required=5 tests=[AWL=0.158] X-Spam-Score: 0.158 X-Spam-Level: X-Archive-Number: 200511/1457 X-Sequence-Number: 76739 Gavin Sherry wrote: > > 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. > There have been async io type parameters in Oracle's init.ora files from (at least) 8i (disk_async_io=true IIRC) - on Solaris anyway. Whether this enabled real or simulated async io is probably a good question - I recall during testing turning it off and seeing kio()? or similar type calls become write()/read() in truss oupout. regards Mark