X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5F0D0D7F16 for ; Sat, 27 Aug 2005 11:35:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48383-04 for ; Sat, 27 Aug 2005 14:35:22 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id B0596D7F10 for ; Sat, 27 Aug 2005 11:35:18 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id C265715255; Sat, 27 Aug 2005 09:35:23 -0500 (CDT) Date: Sat, 27 Aug 2005 09:35:23 -0500 From: "Jim C. Nasby" To: Bruno Wolff III , RAJU kumar , pgsql-admin@postgresql.org Subject: Re: Hash index Message-ID: <20050827143523.GQ11282@pervasive.com> References: <20050826105950.23187.qmail@webmail18.rediffmail.com> <20050827062150.GC27248@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050827062150.GC27248@wolff.to> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 required=5 tests=[AWL=0.011] X-Spam-Level: X-Archive-Number: 200508/360 X-Sequence-Number: 18679 On Sat, Aug 27, 2005 at 01:21:50AM -0500, Bruno Wolff III wrote: > On Fri, Aug 26, 2005 at 10:59:50 -0000, > RAJU kumar wrote: > > ? > > ? > > i want to find out the difference between the btree index and hash index and how exactly the hash index work. > > Why? You probably don't want to use hash indexes as btrees are virtually > always better in the current implementation. That may be true but it's still good to be able to see what they actually do and how they work. In particular it would be good to know what relation they have to the hash operations (HashAgg, HashJoin, etc). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461