[EMAIL PROTECTED] (Kevin Kempter) writes:
> any suggestions for improving "LIKE '%text%'" queries?
If you know that the 'text' portion of that query won't change, then
you might create a partial index on the boolean condition.
That is,
create index index_foo_text on my_table (tfield) where (t
On 10/2/07, Kevin Kempter <[EMAIL PROTECTED]> wrote:
> Hi List;
>
> any suggestions for improving "LIKE '%text%'" queries?
http://www.depesz.com/index.php/2007/09/15/speeding-up-like-xxx/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaste
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Kempter wrote:
> Hi List;
>
> any suggestions for improving "LIKE '%text%'" queries?
faster disks :)
take a look at pg_tgrm and tsearch2.
Sincerely,
Joshua D. Drake
>
>
> Thanks in advance
>
> ---(end of broadcas
Hi List;
any suggestions for improving "LIKE '%text%'" queries?
Thanks in advance
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
