From: Alvaro Herrera <alvherre@surnet.cl>
To: Marc Mamin <m.mamin@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: TIP 9: the planner will ignore... & datatypes
Date: Wed, 1 Jun 2005 09:40:09 -0400
Message-ID: <20050601134009.GA23141@surnet.cl> (raw)
In-Reply-To: <29804.1117619106@www18.gmx.net>
References: <1117616779.3844.903.camel@localhost.localdomain>
<29804.1117619106@www18.gmx.net>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@surnet.cl, m.mamin@gmx.net
Subject: Re: TIP 9: the planner will ignore... & datatypes
In-Reply-To: <20050601134009.GA23141@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox