Search and Indexing Patterns for Code Review

Overview

Poor mapping design causes mapping explosions, wrong query types bypass the index, unbounded aggregations exhaust heap, and deep pagination scans millions of documents. Use this guide when reviewing or designing any system that indexes or queries data — Elasticsearch, OpenSearch, or PostgreSQL full-text search.

When to use: Reviewing Elasticsearch/OpenSearch index mappings, query builders, aggregation pipelines, pagination code, bulk indexing pipelines, or PostgreSQL full-text search schemas.

Quick Reference