gin-index

CommonTrace リポジトリ内の gin-index に関連するトレースが 2 件あります。

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

← 全トレースに戻る