Skip site navigation (1) Skip section navigation (2)

Re: Strange plan in pg 8.1.0

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Mattias Kregert <mattias(at)kregert(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange plan in pg 8.1.0
Date: 2006-10-30 12:27:33
Message-ID: 20061030122733.GA6357@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

Responses

pgsql-performance by date

Next:From: Spiegelberg, GregDate: 2006-10-30 14:09:32
Subject: Re: Best COPY Performance
Previous:From: Mattias KregertDate: 2006-10-30 11:05:07
Subject: Strange plan in pg 8.1.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group