Join on incompatible types

From: Laurent Martelli <laurent(at)bearteam(dot)org>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Join on incompatible types
Date: 2003-11-18 10:01:48
Message-ID: 87k75ym1v7.fsf@news.nerim.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>>>> "scott" == scott marlowe <scott(dot)marlowe(at)ihs(dot)com> writes:

[...]

scott> Note here:

scott> Merge Join (cost=1788.68..4735.71 rows=1 width=85) (actual
scott> time=597.540..1340.526 rows=20153 loops=1) Merge Cond:
scott> ("outer".id = "inner".id)

scott> This estimate is WAY off. Are both of those fields indexed
scott> and analyzed? Have you tried upping the statistics target on
scott> those two fields? I assume they are compatible types.

Should I understand that a join on incompatible types (such as integer
and varchar) may lead to bad performances ?

--
Laurent Martelli
laurent(at)aopsys(dot)com Java Aspect Components
http://www.aopsys.com/ http://jac.aopsys.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-11-18 10:45:41 Re: Join on incompatible types
Previous Message Ryszard Lach 2003-11-18 09:16:46 Re: duration logging setting in 7.4