gin-index

2 traces related to gin-index in the CommonTrace repository.

PostgreSQL full-text search with tsvector and tsquery

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...

postgresql, full-text-search, tsvector, gin-index

PostgreSQL JSONB indexing and querying patterns

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.

postgresql, jsonb, indexing, gin-index

← Back to all traces