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

From Alvaro Herrera
Subject Re: TIP 9: the planner will ignore... & datatypes
Date
Msg-id 20050601134009.GA23141@surnet.cl
Whole thread Raw
In response to TIP 9: the planner will ignore... & datatypes  ("Marc Mamin" <m.mamin@gmx.net>)
List pgsql-performance
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)

pgsql-performance by date:

Previous
From: "Martin Fandel"
Date:
Subject: Re: postgresql-8.0.1 performance tuning
Next
From: Tom Lane
Date:
Subject: Re: How to avoid database bloat