SeqScan with full text search
От | Tomek Walkuski |
---|---|
Тема | SeqScan with full text search |
Дата | |
Msg-id | 5afd048c-19e2-4a81-8439-bc09839d29dc@n5g2000vbf.googlegroups.com обсуждение исходный текст |
Ответы |
Re: SeqScan with full text search
Re: SeqScan with full text search Re: SeqScan with full text search |
Список | pgsql-performance |
Hello group! I have query like this: SELECT employments.candidate_id AS candidate_id, SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* | Two:* | Three:* | Four:*'), 2)) AS ts_rank FROM employments INNER JOIN employers ON employments.employer_id = employers.id AND employers.search_vector @@ TO_TSQUERY('simple', 'One:* | Two:* | Three:* | Four:*') GROUP BY candidate_id; And it results with this: http://explain.depesz.com/s/jLM The JOIN between employments and employers is the culprit. I'm unable to get rid of the seq scan, and setting enable_seqscan to off makes things even worse. Is there any way to get rid of this JOIN? What info should I post to debug this easier? Thanks!
В списке pgsql-performance по дате отправления: