Postgres Pro
Downloads
Home   >   mailing lists

TIP 9: the planner will ignore... & datatypes - Mailing list pgsql-performance

From Marc Mamin
Subject TIP 9: the planner will ignore... & datatypes
Date
Msg-id 29804.1117619106@www18.gmx.net
Whole thread Raw
In response to Re: slow queries, possibly disk io  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: TIP 9: the planner will ignore... & datatypes  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-performance
Tree view 
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 ++

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: slow queries, possibly disk io
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: postgresql-8.0.1 performance tuning