[PERFORM] Impact of varchar/text in use of indexes

2004-03-11 Thread Mike Moran
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

Re: [PERFORM] Impact of varchar/text in use of indexes

2004-03-11 Thread Tom Lane
Mike Moran [EMAIL PROTECTED] writes: 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