Kevin,
I am also interested in a deeper explanation of what you mean by, "The easy
way to do that is just to add a trigram index and search for similar
strings, and forget about full text search." Because I need to make a
decision about whether to use full text search or use other pattern
matching
On Thu, Jul 23, 2015 at 2:55 AM, amihay gonen wrote:
> Hi I'm trying to implement a text search in PG .
>
> My goal to enable the user search on several columns also on partial words.
>
> here is sample code :
> create table test_test( text_data tsvector, text_a varchar,text_b varchar);
>
> inse
amihay gonen wrote:
> explain ANALYZE select * from test_test
> where text_data@@plainto_tsquery('name');
>
> my questions are :
> 1. why the index is not used (I guess it is related to the way
>the data is generated)
Because the sequential scan has a lower cost based on available
statisti
Hi I'm trying to implement a text search in PG .
My goal to enable the user search on several columns also on partial words.
here is sample code :
create table test_test( text_data tsvector, text_a varchar,text_b varchar);
insert into test_test(text_a,text_b) select 'name 10.10.2.3 ','name3 nam
