Full-Text Search Implementation

Implement full-text search in PostgreSQL for:

**Table:** [TABLE_NAME]
**Searchable columns:** [COLUMNS — e.g., "title, description, tags, author_name"]
**Features needed:** [FEATURES — e.g., "fuzzy matching, ranking, highlighting, autocomplete"]

Generate:
1. **tsvector column** — generated column combining searchable fields with weights
2. **GIN index** — index for fast full-text queries
3. **Search query** — ts_query with ranking by relevance
4. **Fuzzy matching** — pg_trgm for typo-tolerant search
5. **Autocomplete** — prefix matching for search-as-you-type
6. **Highlighting** — ts_headline for showing matched snippets
7. **API endpoint** — complete endpoint with pagination and filters
8. **Performance** — benchmark queries and optimization tips

Include the migration SQL, search function, and API route code.