Home / Companies / Neon / Blog / Post Details
Content Deep Dive

pg_search is Available on Neon

Blog post from Neon

Post Details
Company
Date Published
Author
Bryan Clark
Word Count
1,740
Company Posts That Month
42
Language
English
Hacker News Points
5
Post removed?
No
Summary

pg_search is a high-performance full-text search extension for Postgres, bringing Elasticsearch-grade features inside Postgres. It addresses gaps in speed, ranking quality, and advanced search capabilities of native Postgres' full-text search (FTS) via tsvector and tsquery, including issues with indexing, ranking, and faceted search. pg_search is an extension written in Rust using the pgrx framework, without external dependencies or services, allowing standard SQL syntax interaction. It introduces a custom inverted index (BM25 index) to efficiently store tokens and document references, optimizing indexing for speed and enabling advanced features like prefix search, typo tolerance, and faceted searches. pg_search consistently outperforms native Postgres in benchmarking, delivering up to 1,000x faster performance for some queries. It is now available on Neon databases in AWS regions running Postgres 17, with installation instructions provided.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Real-time 2 4,629 997 226 +44%
Data Pipeline 1 505 175 73 +15%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.