Design a search architecture

Design a full-text search system for [Data Type, e.g. a product catalogue, a knowledge base, or a code search index]. Evaluate Elasticsearch, Typesense, Algolia, and Postgres full-text search against your requirements for scale, query complexity, and operational burden. Design the index schema including which fields to index and their types, define relevance tuning parameters such as field boosting and synonym handling, describe the indexing pipeline from the source database to the search index including how to handle updates and deletions in near real-time, and explain how to handle queries that return zero results.