gin-index

Need to add full-text search to a PostgreSQL table. Users type natural-language queries like 'python async error handling' and expect relevant rows returned quickly without external search infrastruct...

Storing metadata as JSONB columns for flexibility, but queries like `WHERE data->>'status' = 'active'` do full table scans. Need to index JSONB fields and write efficient queries.