Re: Strange plan in pg 8.1.0

["Mattias Kregert" <mattias(at)kregert(dot)se>]

> > > From: "Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com>
> On Mon, Oct 30, 2006 at 01:05:07PM +0200, Mattias Kregert wrote:
> >          ->  Hash Left Join  (cost=59.66..206763.11 rows=1215336 
> > width=27) (actual time=4.959..3228.550 rows=1216434 loops=1)
> >                Hash Cond: (("outer".prislista = ("inner".listid)::text) 
> > AND ("outer".tjanst = ("inner".tjanstid)::text))
>
> Note the conversion to text here. Are you sure the types are matching on 
> both
> sides of the join?
>
> /* Steinar */

On the left side it is text, and on the right side it is varchar(10).
Casting left side to varchar(10) does not help, in fact it makes things even 
worse: The cast to ::text vanishes in a puff of logic, but the plan gets 
bigger and even slower (20-25 seconds).

A RIGHT join takes only 20 milliseconds, but i want the left join because 
there could be missing rows in the "prislist" table...

/* m */