TIP 9: the planner will ignore... & datatypes

From: "Marc Mamin" <m(dot)mamin(at)gmx(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: TIP 9: the planner will ignore... & datatypes
Date: 2005-06-01 09:45:06
Message-ID: 29804.1117619106@www18.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ++

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-06-01 09:57:54 Re: postgresql-8.0.1 performance tuning
Previous Message Simon Riggs 2005-06-01 09:06:19 Re: slow queries, possibly disk io