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
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
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
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
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 if our document search
(running on Oracle Text) can be migrated to PostgreSQL, and the reason
I asked that earlier qu
