subject:"\[GENERAL\] index on search \- pg 9.2"

Re: [GENERAL] index on search - pg 9.2

2017-03-14 Thread John R Pierce

On 3/14/2017 7:18 PM, Patrick B wrote: 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 (f

[GENERAL] index on search - pg 9.2

2017-03-14 Thread Patrick B

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