pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTIP 9: the planner will ignore... & datatypes
2+ messages / 2 participants
[nested] [flat]
* TIP 9: the planner will ignore... & datatypes
@ 2005-06-01 09:45 Marc Mamin <m.mamin@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Mamin @ 2005-06-01 09:45 UTC (permalink / raw)
To: 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 ++
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: TIP 9: the planner will ignore... & datatypes
@ 2005-06-01 13:40 Alvaro Herrera <alvherre@surnet.cl>
parent: Marc Mamin <m.mamin@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2005-06-01 13:40 UTC (permalink / raw)
To: Marc Mamin <m.mamin@gmx.net>; +Cc: 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)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-01 13:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-01 09:45 TIP 9: the planner will ignore... & datatypes Marc Mamin <m.mamin@gmx.net>
2005-06-01 13:40 ` Alvaro Herrera <alvherre@surnet.cl>
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