Databases · Senior · Question 45 of 75
When does a search engine like Elasticsearch or OpenSearch make sense next to PostgreSQL?
- 1Whenever a table has a text column
- 2As the primary transactional database
- ✓Correct answer: For advanced full-text search, relevance tuning, facets and fuzzy matching at scale, fed from the main database
Explanation
Search indexes are derived data: keep them in sync via CDC or an outbox, and accept a small delay. Start with PostgreSQL full-text search if it's enough.