search-engine-expert

Search Engine & Full-Text Retrieval Expert (2026 Edition)

English | Bahasa Indonesia

---

English

Orchestration & Integration

• Upstream Data & Schemas: database-orm-expert, data-pipeline-etl-expert
• Vector & Hybrid Search: vector-db-rag-expert, graph-rag-knowledge-expert, xerj-search-expert
• Domain Applications: ecommerce-expert, headless-cms-expert
• Frontend & Performance: senior-frontend, performance-web-vitals, anti-slop
• Lifecycle & Governance: zero-to-prod-orchestrator, session-memory-manager

Description

Production guide for high-performance search engines, typo-tolerant autocomplete, faceted navigation, and hybrid retrieval. Covers native PostgreSQL Full-Text Search (tsvector, GIN index, pg_trgm), dedicated search engines (Typesense, Meilisearch), enterprise distributed clusters (OpenSearch/Elasticsearch), and hybrid search using Reciprocal Rank Fusion (RRF) to merge keyword matching with semantic vector embeddings.

Trigger Conditions

• Implementing instant autocomplete or search-as-you-type beyond simple SQL LIKE %query% filters.
• Setting up faceted e-commerce product navigation (filtering by category, price ranges, ratings).
• Choosing between PostgreSQL built-in FTS vs dedicated clusters (Typesense/Meilisearch).
• Achieving sub-50ms search latency across millions of records.
• Implementing hybrid search combining dense vectors with sparse BM25 / full-text scores.

Level 1: Native PostgreSQL Full-Text Search (Zero Extra Infrastructure)

-- Enable trigram extension for typo tolerance and fuzzy matching
CREATE EXTENSION IF NOT EXISTS pg_trgm;

-- Create articles table with an automated tsvector generated column
CREATE TABLE IF NOT EXISTS articles (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  title VARCHAR(255) NOT NULL,
  content TEXT NOT NULL,
  category VARCHAR(64) NOT NULL,
  search_tokens TSVECTOR GENERATED ALWAYS AS (
    setweight(to_tsvector('english', coalesce(title, '')), 'A') ||
    setweight(to_tsvector('english', coalesce(content, '')), 'B')
  ) STORED
);

-- Crucial: GIN index for full-text queries & Trigram index for typos
CREATE INDEX IF NOT EXISTS idx_articles_fts ON articles USING GIN (search_tokens);
CREATE INDEX IF NOT EXISTS idx_articles_title_trgm ON articles USING GIN (title gin_trgm_ops);

-- Fast ranked query with typo fallback
SELECT 
  id, 
  title, 
  ts_rank_cd(search_tokens, websearch_to_tsquery('english', :query)) AS rank,
  similarity(title, :query) AS sim_score
FROM articles
WHERE search_tokens @@ websearch_to_tsquery('english', :query)
   OR title % :query
ORDER BY rank DESC, sim_score DESC
LIMIT 20;