pg_search 0.26.0
- This Release
- pg_search 0.26.0
- Date
- Status
- Stable
- Other Releases
- Abstract
- One Postgres for your application data, full-text search, vector retrieval, and aggregations
- Description
- pg_search upgrades Postgres with a custom index for fast full-text and vector search, BM25 scoring, filtering, and aggregations. Your application data and search engine live in one database, with no second system to deploy and nothing to sync.
- Released By
- paradedb
- License
- AGPL 3
- Resources
- Special Files
- Tags
Extensions
- pg_search 0.26.0
- Just use Postgres
Documentation
- README
- Top-k by score, restricted by a join (low selectivity)
- README
- cardinality
- README
- bucket_expr_filter
- README
- Foreign Filter, Local Sort
- README
- Scalar COUNT(*) on JOIN
- README
- JoinScan
- README
- Multi-Facet Window Aggregates on JOIN
- README
- sum_int_filter
- DATASET_PREPARATION
- Preparing a Dataset
- README
- top_k_score_multi_term_desc
- README
- TopK Aggregate (Single Table, Tantivy)
- CONTRIBUTING
- Contributing to ParadeDB
- README
- Disjunctive Search Scalar COUNT(*) Aggregate on JOIN
- README
- sum_numeric78_filter
- README
- Permissioned Search (Score Sort)
- README
- GROUP BY aggregate on JOIN
- README
- bucket_numeric_filter
- README
- ParadeDB Benchmarks
- README
- Multiple Aggregates on JOIN
- README
- TopK Score with Tiebreaker (Single Table, BM25)
- README
- ParadeDB Documentation
- THANKYOU
- ParadeDB Thank You Page
- README
- Stressgres
- README
- Disjunctive Search across Normalized Hierarchy (Local Sort)
- README
- TopK Score DESC, Low Selectivity (Single Table, BM25)
- README
- TopK Score DESC with Range Filter, Low Selectivity (Single Table, BM25)
- README
- sum_numeric15_filter
- README
- count_nofilter
- README
- PostgreSQL Regression Tests for ParadeDB
- README
- bucket_string_nofilter
- README
- TopK Score DESC, High Selectivity (Single Table, BM25)
- README
- TopK Aggregate on JOIN (DataFusion)
- README
- Semi-Join Filter (Term Set)
- avl
- avl
- RELEASE
- ParadeDB Release Process
- README
- TopK Score DESC, Medium Selectivity (Single Table, BM25)
- README
- Disjunctive Search across Normalized Hierarchy (Score Sort)
- CODE_OF_CONDUCT
- Contributor Covenant Code of Conduct
- README
- Distinct Parent Sort (Join Explosion)
- README
- Conjunctive Search across Normalized Hierarchy (Score Sort)
- CHANGELOG
- ParadeDB Changelog
- README
- TopK Score DESC with Range Filter, High Selectivity (Single Table, BM25)
- SECURITY
- Security Policy
- README
- count_filter
- README
- bucket_numeric_nofilter
- README
- bucket_string_filter
- README
- ParadeDB Dockerfiles
- README
- TopK Score DESC with Range Filter, Medium Selectivity (Single Table, BM25)
- README
- Test suite for pg_search
- README
- Diagnosing Quantized Vector Indexes
- README
- Stack Overflow Benchmark Suite
- README
- Aggregate Sort (Computed Property)
- README
- Date Histogram on JOIN
README
Contents
Just use Postgres.
One Postgres for your application data, full-text search, vector retrieval, and aggregations.
Website • Docs • Community • Blog • Changelog
Installation
To run ParadeDB locally with Docker and open a psql session:
curl -fsSL https://paradedb.com/install.sh | sh
When you’re ready to deploy, get started on ParadeDB Cloud for a fully managed experience, or explore our self-hosted deployment options.
What is ParadeDB?
ParadeDB upgrades Postgres with a custom index for fast full-text and vector search, BM25 scoring, filters, facets, aggregations, and joins. Built as a Postgres extension, it keeps your application data and search engine in one database with standard SQL and ACID transactions.
- [x] Full-Text Search
- [x] BM25 Scoring
- [x] Top K
- [x] Highlighting
- [x] Tokenizers & Token Filters
- [x] Vector Search
- [x] Hybrid Search
- [x] Filtering
- [x] Aggregates
- [x] Columnar Storage
- [x] Bucket & Metrics
- [x] Facets
- [x] JOINs
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 and vector 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
- Drizzle
- Django
- SQLAlchemy
- Rails
- EF Core
- More coming (Prisma, and others)
AI Agents
PaaS Providers
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.
ParadeDB Enterprise is commercially licensed and included with ParadeDB Cloud. To self-host ParadeDB Enterprise, contact sales.