Re: hash index improving v3

Tom Lane <[email protected]> Thu, 04 Sep 2008 22:19:05 -0400

Newsgroups	gmane.comp.db.postgresql.devel.patches
Message-ID	<[email protected]>

"Alex Hunsaker" <[email protected]> writes:
> On Thu, Sep 4, 2008 at 7:13 PM, Tom Lane <[email protected]> wrote:
>> * check that the queries actually use the indexes (not sure that the
>> proposed switch settings ensure this, not to mention you didn't create
>> the indexes)

> Well I was assuming I could just test the speed of a hash join...

Uh, no, hash joins have nearly zip to do with hash indexes.  They rely
on the same per-datatype support functions but that's the end of the
commonality.

			regards, tom lane

-- 
Sent via pgsql-patches mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches