MongoDB Cheatsheet 18 — Atlas Search
Cheatsheet: $search, autocomplete, facets, scoring.
Search
Design a Search System — From LIKE Queries to Hybrid Vector Search
Search system at every scale: Postgres FTS for small apps, Elastic / OpenSearch for keyword scale, hybrid (BM25 + vectors) for modern relevance, and ranking discipline.
Hybrid Search with Postgres in 2026 — pgvector + FTS + Reranker
Production hybrid search with Postgres alone: pgvector for semantic, tsvector for lexical, RRF fusion for combining, optional reranker. Performance, tuning, and patterns.
Design a Search System — Elasticsearch, OpenSearch, and Postgres FTS in 2026
End-to-end search system design. Engine choice, indexing pipeline, ranking, hybrid search with embeddings, multi-tenancy, and the operational realities.
PostgreSQL Full-Text Search Without an Extra Service
Postgres ships with surprisingly capable full-text search built-in. Here’s how to use it for ranked text search without adding Elasticsearch to your stack.