| From: | Marc McIntyre <mmcintyre(at)squiz(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: LIKE query problem |
| Date: | 2006-09-19 03:16:48 |
| Message-ID: | 450F6120.6010208@squiz.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Thanks Tom,
Is that documented somewhere? I can't seem to see any mention of it in
the docs.
Tom Lane wrote:
> Marc McIntyre <mmcintyre(at)squiz(dot)net> writes:
>
>> ... Is there a way to perform this efficiently in one query ?
>>
>
> No, because you're hoping for an indexscan optimization of a LIKE
> query, and that can only happen if the pattern is a plan-time constant.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Turner | 2006-09-19 03:40:16 | Re: Large tables (was: RAID 0 not as fast as expected) |
| Previous Message | Tom Lane | 2006-09-19 02:50:19 | Re: LIKE query problem |