Home PostgreSQL fulltext search index
Reply: 0

PostgreSQL fulltext search index

user450 Published in June 20, 2018, 12:05 am

I have a table with text fields and I need efficient full text search. I found out some technics and I wonder is it better to extend schema by creating additional ts_vector field based on text fields or i can save my schema and just create index this way:

CREATE INDEX pgweb_idx ON pgweb USING GIN (to_tsvector('english', title || ' ' || body));

Is there any difference in the sense of efficiency?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.313191 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO