| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | gbarosio(at)uolsinectis(dot)com(dot)ar |
| Cc: | tim(dot)leeuwvander(at)nl(dot)unisys(dot)com, mailing(at)impactmedia(dot)de, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: No index usage with |
| Date: | 2004-08-02 12:47:20 |
| Message-ID: | 200408021247.i72ClKL21226@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
G u i d o B a r o s i o wrote:
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
And this is fixed in 7.5/8.0.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2004-08-02 12:47:29 | Re: What kind of performace can I expect and how to measure? |
| Previous Message | Rod Taylor | 2004-08-02 12:45:22 | Re: No index usage with "left join" |