Re: [PERFORM] Tsearch2 - bad performance with concatenated ts-vectors

2011-10-24 Thread Robert Haas
On Tue, Aug 2, 2011 at 2:22 AM, Jan Wielgus wrote: > So, there is apparently a problem with vector concatenating - the indexes > don't work then. I tried to use the vectors separately and to make 'OR' > comparison between single vector @@ ts_query checks, > but it didn't help very much (performa

Re: [PERFORM] Tsearch2 - bad performance with concatenated ts-vectors

2011-08-04 Thread Kevin Grittner
Gavin Flower wrote: > I am experimenting with formatting styles, especially relating to > joins. Because I have poor eyesight: visual clues are important, > so that I can focus on key points. Hence the use of > abbreviations, naming conventions, and careful indenting. > So I would like peo

Re: [PERFORM] Tsearch2 - bad performance with concatenated ts-vectors

2011-08-04 Thread Gavin Flower
On 02/08/11 18:22, Jan Wielgus wrote: select participant.participant_id from participant participant join person person on person.person_participant_id = participant.participant_id left join registration registration on registration.registration_registered_participant_id = participant.participan