Best for
Full-text search, relevance ranking, logs, and template-driven query systems.Add when product search, document search, or logs outgrow SQL LIKE queries.Teams choose it when the search workload is a real product need.
Back to choosersearch database
Elasticsearch
Full-text search, relevance ranking, logs, and template-driven query systems.
Common use cases
- Full-text search, relevance ranking, logs, and template-driven query systems.
- Add when product search, document search, or logs outgrow SQL LIKE queries.
- Teams choose it when the search workload is a real product need.
When not to use it
You need transactional writes or the only source of truth for product orders.
Common pairings
PostgreSQLRedisOpenSearch
Use it when the workload clearly matches; keep the first version operationally simple.
Keep learning before you build.
This page is educational first. Use the project workflow only when you are ready to turn the choice into evidence and a report.