[GENERAL] index on search - pg 9.2 - Mailing list pgsql-general

From Patrick B
Subject [GENERAL] index on search - pg 9.2
Date
Msg-id CAJNY3itPEvqoNat4zh4Lvwf5iqP_b+7hcoTfSK-EyDnfbpJH3g@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] index on search - pg 9.2  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Hi guys

I've got a query that is doing a search with wildcards:
OR (description LIKE '%change%')

Query: - Taking > 14 secs to run
SELECT j.id, ff.gtime
FROM public.status AS s
JOIN public.job AS j ON j.status_label_id = s.id AND j.clientid = 3369
JOIN public.log AS ff ON ff.jobid = j.id
AND ff.clientid = 3369
AND (ff.description LIKE '%change%')
ORDER BY gtime DESC
LIMIT 100


I'm using PG 9.2 and, read about gin indexes.
I've created the index to test, but the query is not using it.
create index on log gin (description gin_trgm_ops)

Can you guys help to improve that part please?

Patrick.

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] index on search - pg 9.2