Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 5930565013E
	for <pgsql-patches-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 22:54:56 -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 51510-07 for
	<pgsql-patches-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 22:54:53 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152])
	by postgresql.org (Postfix) with ESMTP id 4DDE3650138
	for <pgsql-patches@postgresql.org>;
	Thu,  4 Sep 2008 22:54:53 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so647267fgg.23
	for <pgsql-patches@postgresql.org>;
	Thu, 04 Sep 2008 18:54:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=m+9W61SFAeVHQpDi62fhDcsXbHqDJ8YhDI/BA+Nk4UI=;
	b=LKQdqATrqYtwmROUleUxPlUkWJcdHiyplJM70n/959Kg8/UnQeKQxBYxSN6Z+ufdKa
	veauZ9wAa4+VYuWFIje9BCwLKwmuVfpTY5b46iD4OL7XaUF+94SsFFlyu8EIA0YEuIhf
	TdTcRA4gVlFSpwYa61dyNLefQbCnScQSx9NrY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=vDKDCMhgKXTjtnMwQsM4KaYjqhexO/EJkuAu9O/PqZqDrP+OvMlbY4Fhv46YBky+9J
	WIKjaOIpI/Uhn0bIA+1wiHpiHWDWauLx11GkxTB8OtmRI3I0eZ6k68y98K0kMr6TDr17
	NiLRKeXP+DCpUmtfPLP7zRi/0h5Cn2rHDXEqY=
Received: by 10.187.219.6 with SMTP id w6mr2514909faq.29.1220579691107;
	Thu, 04 Sep 2008 18:54:51 -0700 (PDT)
Received: by 10.187.225.11 with HTTP; Thu, 4 Sep 2008 18:54:51 -0700 (PDT)
Message-ID: <34d269d40809041854g355a8f68ga3a037a69e3d9fcb@mail.gmail.com>
Date: Thu, 4 Sep 2008 19:54:51 -0600
From: "Alex Hunsaker" <badalex@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: hash index improving v3
Cc: "Zdenek Kotala" <Zdenek.Kotala@sun.com>,
 "Xiao Meng" <mx.cogito@gmail.com>,
	pgsql-patches@postgresql.org, "Jonah H. Harris" <jonah.harris@gmail.com>
In-Reply-To: <11525.1220579153@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com>
	<48BFDA8D.3080506@sun.com> <29987.1220560114@sss.pgh.pa.us>
	<7627.1220569888@sss.pgh.pa.us>
	<34d269d40809041742r6a0703dbgfbdd012f7f19de2e@mail.gmail.com>
	<10995.1220577198@sss.pgh.pa.us> <11525.1220579153@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200809/47
X-Sequence-Number: 7062

On Thu, Sep 4, 2008 at 7:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So what we need for testing is a few different key values that hash to
> the same code.  Not sure about an easy way to find such.

Hrm, well I have not really looked at the hash algorithm but I assume
we could just reduce the number of buckets?