Re: [PERFORM] ORDER BY using index, tsearch2

2013-12-12 Thread Janek Sendrowski
Okay thanks. That's what I wanted to know. Janek Sendrowski -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] ORDER BY using index, tsearch2

2013-12-11 Thread Janek Sendrowski
uery)" My PG-version is 9.3. I was wondering about this feature, bacause I haven't seen it yet and it a huge speed up. Sorry, I thought the name is still tsearch, because the functionnames are roughly the same, but now know I noticed, that this name is obsolete. Janek Sendrowski

[PERFORM] ORDER BY using index, tsearch2 [READ THIS!]

2013-12-11 Thread Janek Sendrowski
t find the "><" operator in any introduction of the tsearch2 extension. Is it just an idea?   Thanks for your help! Janek Sendrowski -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] ORDER BY using index, tsearch2

2013-12-11 Thread Janek Sendrowski
in any introduction of the tsearch2 extension. Is it just an idea?   Thanks for your help! Janek Sendrowski

[PERFORM] Similarity search with the tsearch2 extension

2013-12-06 Thread Janek Sendrowski
7; 'weigh' (1 row)   SELECT * FROM tablename WHERE vector @@ to_tsquery('speci & tiger & total & weigh') AND vector @@ to_tsquery('largest & length & m & reach')  AND vector @@ to_tsquery('3.3 & 306 & bodi & cat & kg'