From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
---|---|
To: | postgresql performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | index on different types |
Date: | 2005-04-29 02:35:13 |
Message-ID: | 20050429023512.GB26200@nibiru.borg.metux.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi folks,
there's often some talk about indices cannot be used if datatypes
dont match.
On a larger (and long time growed) application I tend to use OID
for references on new tables while old stuff is using integer.
Is the planner smart enough to see both as compatible datatype
or is manual casting required ?
thx
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-04-29 03:28:34 | Re: index on different types |
Previous Message | Marko Ristola | 2005-04-28 17:44:37 | Re: [HACKERS] Bad n_distinct estimation; hacks suggested? |