Re: [PERFORM] SeqScan with full text search

2012-04-17 Thread Віталій Тимчишин
2012/4/16 Tomek Walkuski > 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 employm

Re: [PERFORM] SeqScan with full text search

2012-04-16 Thread Merlin Moncure
On Mon, Apr 16, 2012 at 9:02 AM, Tomek Walkuski wrote: > 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

Re: [PERFORM] SeqScan with full text search

2012-04-16 Thread Tomas Vondra
On 16.4.2012 16:02, Tomek Walkuski wrote: > 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 >

[PERFORM] SeqScan with full text search

2012-04-16 Thread Tomek Walkuski
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 employe