The real argument is not whether PostgreSQL can search text or whether Elasticsearch can store documents. Both can. The interesting question is where search complexity should live. PostgreSQL full text search lives inside a transactional relational database with tsvector, tsquery, dictionaries, ranking, and GIN indexes. Elasticsearch is a distributed search and analytics engine built on Lucene, wi
PostgreSQL Full Text Search vs Elasticsearch Comparison
Rost·Dev.to··1 min read
D
Continue reading on Dev.to
This article was sourced from Dev.to's RSS feed. Visit the original for the complete story.