Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9C2879F9F47; Fri, 17 Nov 2006 10:38:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 35773-08; Fri, 17 Nov 2006 14:38:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id DD10D9F9CF9; Fri, 17 Nov 2006 10:38:40 -0400 (AST) thread-index: AccKVhPUJAmlYn06Q5qHnsisKSCv9A== Received: from [192.168.0.20] ([62.232.55.118]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 17 Nov 2006 09:38:40 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-class: urn:content-classes:message Importance: normal Subject: Re: [PERFORM] BUG #2737: hash indexing largetablefails, while btree of same index works From: "Simon Riggs" To: "Kenneth Marshall" Cc: "Tom Lane" , "Balazs Nagy" , , In-Reply-To: <20061117142657.GQ12572@it.is.rice.edu> References: <200611051347.kA5DlVCk032222@wwwmaster.postgresql.org> <7530.1163202951@sss.pgh.pa.us> <1163233075.3634.944.camel@silverbirch.site> <1884.1163717296@sss.pgh.pa.us> <1163761151.27956.592.camel@silverbirch.site> <20061117142657.GQ12572@it.is.rice.edu> Content-Type: text/plain; charset="iso-8859-1" Date: Fri, 17 Nov 2006 14:38:12 +0000 Message-ID: <1163774292.27956.705.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 17 Nov 2006 14:38:41.0656 (UTC) FILETIME=[13A78780:01C70A56] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/119 X-Sequence-Number: 16254 On Fri, 2006-11-17 at 08:26 -0600, Kenneth Marshall wrote: > I certainly hold out some hope that they can improved. I would like to see > them still included. Once they are gone, it will be much harder to ever > add them back. OK, you got it - keep hash indexes then. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com