Re: [GENERAL] Full Text Search ideas

2010-07-20 Thread Oleg Bartunov
It's doable. but requires a lot of work. We need support for this. Oleg On Sun, 18 Jul 2010, Howard Rogers wrote: I asked recently about a performance problem I'd been having with some full text queries, and got really useful help that pointed me to the root issues. Currently, I'm trying to see

Re: [GENERAL] Full Text Search ideas

2010-07-19 Thread Steve Grey
On 19 July 2010 01:46, Howard Rogers wrote: > On Mon, Jul 19, 2010 at 6:16 AM, Tom Lane wrote: > > Howard Rogers writes: > >> ims=# select count(*) from search_rm > >> where to_tsvector('english', textsearch) @@ to_tsquery('english','bat & > sb12n'); > >> count > >> --- > >> 3849 > >> (1 r

Re: [GENERAL] Full Text Search ideas

2010-07-18 Thread Howard Rogers
On Mon, Jul 19, 2010 at 6:16 AM, Tom Lane wrote: > Howard Rogers writes: >> ims=# select count(*) from search_rm >> where to_tsvector('english', textsearch) @@ to_tsquery('english','bat & >> sb12n'); >> count >> --- >>  3849 >> (1 row) > >> Time: 408.962 ms > >> ims=# select count(*) from se

Re: [GENERAL] Full Text Search ideas

2010-07-18 Thread Tom Lane
Howard Rogers writes: > ims=# select count(*) from search_rm > where to_tsvector('english', textsearch) @@ to_tsquery('english','bat & > sb12n'); > count > --- > 3849 > (1 row) > Time: 408.962 ms > ims=# select count(*) from search_rm > where to_tsvector('english', textsearch) @@ to_tsquer