Skip site navigation (1) Skip section navigation (2)

Re: LIKE query problem

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 (view raw or flat)
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
>
>   


In response to

pgsql-performance by date

Next:From: Alex TurnerDate: 2006-09-19 03:40:16
Subject: Re: Large tables (was: RAID 0 not as fast as expected)
Previous:From: Tom LaneDate: 2006-09-19 02:50:19
Subject: Re: LIKE query problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group