# How Multica Full-Text Search Works: A Technical Deep Dive

> Discover how Multica full-text search leverages PostgreSQL GIN indexes and the pg_bigm extension for efficient, relevant search results via REST APIs. Learn the technical details.

- Repository: [multica-ai/multica](https://github.com/multica-ai/multica)
- Tags: deep-dive
- Published: 2026-04-11

---

**Multica implements full-text search directly in the PostgreSQL layer using GIN indexes with the pg_bigm extension, processing queries through REST endpoints that dynamically generate parameterized SQL with relevance ranking and snippet extraction.**

Multica is an open-source project management platform (multica-ai/multica) that delivers fast, CJK-friendly search across issues and projects without requiring external search engines like Elasticsearch. This guide examines how Multica full-text search operates by tracing the complete query lifecycle from HTTP request handling through PostgreSQL execution, including the specific ranking algorithms and indexing strategies defined in the source code