[PERFORM] TIP 9: the planner will ignore... datatypes

[Marc Mamin]

TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


But INT2, INT4, INT8 and SERIAL are considered to be a unique datatype.
Am I Right?

Thanks,

Marc

-- 
Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis
++ Jetzt anmelden  testen ++ http://www.gmx.net/de/go/promail ++

---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [PERFORM] TIP 9: the planner will ignore... datatypes

[Alvaro Herrera]

On Wed, Jun 01, 2005 at 11:45:06AM +0200, Marc Mamin wrote:
 TIP 9: the planner will ignore your desire to choose an index scan if your
   joining column's datatypes do not match
 
 
 But INT2, INT4, INT8 and SERIAL are considered to be a unique datatype.
 Am I Right?

No, they weren't when this tip was written.  As of 8.0 however this tip
is no longer the complete truth; we do allow cross-type index scans.

-- 
Alvaro Herrera (alvherre[a]surnet.cl)
I suspect most samba developers are already technically insane...
Of course, since many of them are Australians, you can't tell. (L. Torvalds)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster