Consensus recommendation from the panel, especially Stephen and Caio: before adopting Elasticsearch for a big-dataset filterable index endpoint, use Postgres (or SQLite) with proper indexes, load-test across environments, and find the Pareto-hot filter combinations. Only reach for a secondary index store if you actually outgrow the relational database. Don't fear joins — Postgres handles 20+ joins fine.