Laurent Martelli wrote:
Shridhar == Shridhar Daithankar [EMAIL PROTECTED] writes:
Shridhar Laurent Martelli wrote:
[...]
Should I understand that a join on incompatible types (such as
integer and varchar) may lead to bad performances ?
Shridhar Conversely, you should enforce strict
Laurent Martelli wrote:
Shridhar == Shridhar Daithankar [EMAIL PROTECTED] writes:
[...]
Shridhar 2. Try following query EXPLAIN ANALYZE SELECT * from lists
Shridhar join classes on classes.id=lists.value where
Shridhar lists.id='16'::integer;
Shridhar classes.id=lists.value::integer.
Laurent Martelli wrote:
scott == scott marlowe [EMAIL PROTECTED] 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.
Shridhar == Shridhar Daithankar [EMAIL PROTECTED] writes:
Shridhar Laurent Martelli wrote:
[...]
Should I understand that a join on incompatible types (such as
integer and varchar) may lead to bad performances ?
Shridhar Conversely, you should enforce strict type compatibility