pg_search is Available on Neon

Neon has integrated pg_search, a high-performance full-text search extension written in Rust, to enhance its PostgreSQL capabilities, offering Elasticsearch-level speed for search-heavy applications and large datasets. This extension addresses the limitations of native PostgreSQL full-text search by providing advanced features such as the BM25 algorithm for better relevance ranking, typo tolerance, prefix search, and faceted search capabilities, without requiring external dependencies or services. The integration allows for real-time updates and immediate consistency in search results, significantly improving search performance, as demonstrated by benchmarks showing up to 1,000x faster query execution compared to a tuned Postgres instance using GIN indexes. The extension is fully integrated with PostgreSQL's MVCC system, ensuring concurrent access and immediate searchability of new data, making it particularly suitable for live applications.