Hi List;
any suggestions for improving LIKE '%text%' queries?
Thanks in advance
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
-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
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 postmaster
[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