| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: not using partial index |
| Date: | 2011-04-20 13:25:57 |
| Message-ID: | 25018.1303305957@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Willy-Bas Loos <willybas(at)gmail(dot)com> writes:
> [ NOT field1 ISNULL is not seen as equivalent to field1 IS NOT NULL ]
> Any ideas why this might be?
The planner does not spend an infinite number of cycles on trying to
make different expressions look alike.
As it happens, 9.1 does know this equivalence, as a byproduct of
http://git.postgresql.org/gitweb?p=postgresql.git&a=commitdiff&h=220e45bf325b061b8dbd7451f87cedc07da61706
But I don't consider it a bug that older versions don't do it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurent Laborde | 2011-04-20 14:01:22 | Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1 |
| Previous Message | Jeff | 2011-04-20 12:39:07 | Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1 |