[PERFORM] performance of like queries

2007-10-02 Thread Kevin Kempter
Hi List; any suggestions for improving LIKE '%text%' queries? Thanks in advance ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] performance of like queries

2007-10-02 Thread Joshua D. Drake
-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

Re: [PERFORM] performance of like queries

2007-10-02 Thread Marcin Stępnicki
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

Re: [PERFORM] performance of like queries

2007-10-02 Thread Chris Browne
[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