| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Reece Hart <reece(at)in-machina(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: explicit casting required for index use |
| Date: | 2003-10-27 09:18:53 |
| Message-ID: | 1067246333.457.12.camel@tokyo |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Sat, 2003-10-25 at 13:49, Reece Hart wrote:
> Having to explicitly cast criterion is very non-intuitive. Moreover,
> it seems quite straightforward that PostgreSQL might incorporate casts
This is a well-known issue with the query optimizer -- search the
mailing list archives for lots more information. The executive summary
is that this is NOT a trivial issue to fix, and it hasn't been fixed in
7.4, but there is some speculation on how to fix it at some point in the
future.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Zanella | 2003-10-27 09:40:53 | Re: incrementing and decrementing dates by day increments programmatically |
| Previous Message | Adam Witney | 2003-10-27 08:54:21 | Re: shared memory on OS X - 7.4beta4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-10-27 10:08:49 | Re: Performance Concern |
| Previous Message | Dror Matalon | 2003-10-27 07:43:57 | Re: Various performance questions |