pg-textsearch

What problem does it solve?

This Skill provides advanced, corpus-aware full-text search capabilities for PostgreSQL databases, offering superior ranking and performance compared to native solutions.

Core Features & Use Cases

• BM25 Ranking: Implements BM25 scoring for more relevant search results.
• Hybrid Search: Enables combining BM25 keyword search with vector-based semantic search using Reciprocal Rank Fusion (RRF).
• Performance Tuning: Offers detailed configuration and monitoring for optimizing text search performance.
• Use Case: Integrate powerful keyword search into an e-commerce product catalog or a knowledge base, ensuring users find relevant information quickly.

Quick Start

Create a BM25 index on the 'description' column of the 'listing' table using the 'russian' text configuration.