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 61D1AD7E14 for ; Sat, 27 Aug 2005 03:22:14 -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 44819-03 for ; Sat, 27 Aug 2005 06:22:12 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id C3D3AD736E for ; Sat, 27 Aug 2005 03:22:11 -0300 (ADT) Received: (qmail 28499 invoked by uid 500); 27 Aug 2005 06:21:50 -0000 Date: Sat, 27 Aug 2005 01:21:50 -0500 From: Bruno Wolff III To: RAJU kumar Cc: pgsql-admin@postgresql.org Subject: Re: Hash index Message-ID: <20050827062150.GC27248@wolff.to> Mail-Followup-To: Bruno Wolff III , RAJU kumar , pgsql-admin@postgresql.org References: <20050826105950.23187.qmail@webmail18.rediffmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20050826105950.23187.qmail@webmail18.rediffmail.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/356 X-Sequence-Number: 18675 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.