Impact of varchar/text in use of indexes - Mailing list pgsql-performance

From Mike Moran
Subject Impact of varchar/text in use of indexes
Date
Msg-id 4050AF10.9060006@mac.com
Whole thread Raw
Responses Re: Impact of varchar/text in use of indexes
List pgsql-performance
Hi. I have two existing tables, A and B. A has a 'varchar(1000)' field
and B has a 'text' field, each with btree indexes defined. When I do a
join between these, on this field, it seems to a hash join, as opposed
to using the indexes, as I might expect (I'm no postgres expert, btw).

My question is: if I changed both fields to be text or varchar(1000)
then would the index be used?

Ta,

--
Mike



pgsql-performance by date:

Previous
From: brew@theMode.com
Date:
Subject: Re: started Data Warehousing
Next
From: Andrew Sullivan
Date:
Subject: Re: compiling 7.4.1 on Solaris 9