23

Read Query

In Posgres, Full text indexing allows documents to be preprocessed and an index saved for later rapid searching. Preprocessing includes:

  • Parsing documents into tokens.

  • Converting tokens into lexemes.

  • Storing preprocessed documents optimized for searching.

tsvector type is used in Postgres for full text search

tsvector type is different than text type in below aspects:

  • Eliminates case. Upper/lower case letter are identical

  • Removes stop words ( and, or, not, she, him, and hundreds of others)-because these words are not relevant for text search

  • Replaces synonyms and takes word stems (elephant -> eleph). In the full text catalogue, it does not have the word elephant but the word elep.

  • Can (and should) be indexed with GIST and GIN

  • Custom ranking with weights & ts_rank

How Elastic search(search engine) has advantage over full text search in Postgres?

Improve this question

1 Answer 1

Reset to default
11

fulltext search and elasticsearch are both built on the same basic technology inverted indices so performance is going to be about the same.

FTS is going to be easier to deploy.

ES comes with lucene,

if you want lucene with FTS that will require extra effort.

Improve this answer
Sign up to request clarification or add additional context in comments.

13 Comments

For full text search, apart from Postgres database setup, do we need anything else for deployment?
no other components re required, there is however quite a lot to read and understand before it can be used..
Major advantage could be Elastic carries NoSQL database where as PostGres is OODBMS... For example: For text search from multiple data sources.. gathering the data from multiple data sources to NoSQL makes more sense...
NoSQL does not add anything.
This answer talks about heterogenous data, where MongoDB is preferred over PostGreSQL
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.