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 */
--
Homepage: http://www.sesse.net/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly