Multiple ChoiceHard 30s
Full-text search
Choose the best answer for: full-text search
Options
- 1tsvector/tsquery in PostgreSQL; Elasticsearch for scale
- 2B-tree indexes in MySQL; trigram indexes for LIKE
- 3Elasticsearch for writes; Postgres for read replicas
- 4LIKE queries with wildcards; regex for scale
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.