Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 29B8865031C for ; Sat, 12 Jul 2008 08:34:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04058-02 for ; Sat, 12 Jul 2008 08:34:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fugue.toroid.org (fugue.toroid.org [85.10.196.113]) by postgresql.org (Postfix) with ESMTP id 66DAE6500A0 for ; Sat, 12 Jul 2008 08:34:34 -0300 (ADT) Received: from penne.toroid.org (penne-vpn [10.8.0.6]) by fugue.toroid.org (Postfix) with ESMTP id 9A26D558524; Sat, 12 Jul 2008 13:34:32 +0200 (CEST) Received: by penne.toroid.org (Postfix, from userid 1000) id E75BDADC364; Sat, 12 Jul 2008 17:04:32 +0530 (IST) Date: Sat, 12 Jul 2008 17:04:32 +0530 From: Abhijit Menon-Sen To: Gregory Stark Cc: Zoltan Boszormenyi , pgsql-hackers@postgresql.org Subject: Re: posix advises ... Message-ID: <20080712113432.GA26415@toroid.org> References: <4826C200.8060807@cybertec.at> <485A3F20.1080907@cybertec.at> <20080711100215.GA14893@toroid.org> <87abgo0yid.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <87abgo0yid.fsf@oxford.xeocode.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/613 X-Sequence-Number: 120873 At 2008-07-12 00:52:42 +0100, stark@enterprisedb.com wrote: > > There was some discussion about this change and in fact if you > look at CVS HEAD you'll find it already applied. Not as far as I can see. > Incrementing the most significant index keys would maximize the > distance we're jumpin around in the index tree. I see. Thanks. > The later versions of mine had a GUC named effective_spindle_count > which I think is nicely abstracted away from the implementation > details. Yes, that does sound much better. (The patch I read had a preread_pages_bitmapscan variable instead.) -- ams