WITH ja_jobs as (SELECT DISTINCT title FROM ja_jobs WHERE clientid = 31239 AND time_job > 1457826264 ) SELECT title FROM ja_jobs WHERE title ILIKE 'RYAN WER%' ORDER BY title LIMIT 10;
hmm.. still slow =(
and it's not hitting the index: (i had to change the clientid because the previous one was in cache)