pg_search 0.23.0
- This Release
- pg_search 0.23.0
- Date
- Status
- Stable
- Other Releases
- Abstract
- Full text search for PostgreSQL using BM25
- Description
- ParadeDB pg_search is a Postgres extension that enables fast full-text, faceted and hybrid search over Postgres tables using the BM25 algorithm. It is built on top of Tantivy, the Rust-based alternative to Apache Lucene, using pgrx.
- Released By
- paradedb
- License
- AGPL 3
- Resources
- Special Files
- Tags
Extensions
- pg_search 0.23.0
- Postgres for Search and Analytics
Documentation
- README
- Stressgres
- DATASET_PREPARATION
- Preparing a Dataset
- RELEASE
- ParadeDB Release Process
- CHANGELOG
- ParadeDB Changelog
- README
- ParadeDB Benchmarks
- SECURITY
- Security Policy
- THANKYOU
- ParadeDB Thank You Page
- CONTRIBUTING
- Contributing to ParadeDB
- README
- PostgreSQL Regression Tests for ParadeDB
- README
- JoinScan
- CODE_OF_CONDUCT
- Contributor Covenant Code of Conduct
- avl
- avl
- README
- ParadeDB Documentation
- README
- Test suite for pg_search
README
Contents
Simple, Elastic-quality search for Postgres
Website • Docs • Community • Blog • Changelog
Installation
curl -fsSL https://paradedb.com/install.sh | sh
When you’re ready to deploy, check out our hosting options.
What is ParadeDB?
ParadeDB is a PostgreSQL extension that brings Elastic-quality full-text search and analytics directly inside Postgres.
- [x] Full-Text Search
- [x] BM25 Scoring
- [x] Top K
- [x] Highlighting
- [x] Tokenizers & Token Filters
- [x] Filtering
- [x] Aggregates
- [x] Columnar Storage
- [x] Bucket & Metrics
- [x] Facets
- [x] JOINs
- [ ] Vector Search (coming soon)
- [ ] Hybrid Search (coming soon)
Star and watch this repository to follow along. See our current projects and long-term roadmap.
How It Works
ParadeDB integrates battle-tested Rust libraries for search and analytics inside Postgres, contributing upstream whenever possible. Our primary dependencies are:
- pgrx — bridges Postgres and Rust
- Tantivy — powers full-text search
- Apache DataFusion — handles OLAP processing
For a deeper dive, see our architecture docs or CMU Database Group talk.
Integrations
ParadeDB integrates with the tools you already use, with more on the way.
ORMs & Frameworks
- Django
- SQLAlchemy
- Rails
- More coming (Prisma, and others)
AI Agents
PaaS & Cloud Platforms
- Railway
- Render
- DigitalOcean
- More coming (Heroku, and others)
Community & Support
- Slack — ask questions, share what you’re building
- GitHub Discussions — longer-form Q&A
- GitHub Issues — bug reports and feature requests
- Email — enterprise support and commercial licensing
Contributing
We welcome contributions of all sizes! Check out our good first issues to get started. For larger contributions, we recommend discussing them with us in Slack first. See our Contributing Guide and Code of Conduct for details.
License
ParadeDB Community is licensed under the GNU Affero General Public License v3.0. For ParadeDB Enterprise licensing, contact sales@paradedb.com.