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
- CONTRIBUTING
- Contributing to ParadeDB
- README
- TopK Aggregate (Single Table, Tantivy)
- DATASET_PREPARATION
- Preparing a Dataset
- README
- top_k_score_multi_term_desc
- README
- Scalar COUNT(*) on JOIN
- README
- JoinScan
- README
- Multi-Facet Window Aggregates on JOIN
- README
- sum_int_filter
- README
- cardinality
- README
- bucket_expr_filter
- README
- Foreign Filter, Local Sort
- README
- Top-k by score, restricted by a join (low selectivity)
- README
- TopK Score DESC with Range Filter, Low Selectivity (Single Table, BM25)
- README
- count_nofilter
- README
- sum_numeric15_filter
- README
- Stressgres
- README
- TopK Score DESC, Low Selectivity (Single Table, BM25)
- README
- Disjunctive Search across Normalized Hierarchy (Local Sort)
- THANKYOU
- ParadeDB Thank You Page
- README
- ParadeDB Documentation
- README
- Multiple Aggregates on JOIN
- README
- TopK Score with Tiebreaker (Single Table, BM25)
- README
- ParadeDB Benchmarks
- README
- GROUP BY aggregate on JOIN
- README
- bucket_numeric_filter
- README
- Permissioned Search (Score Sort)
- README
- sum_numeric78_filter
- README
- Disjunctive Search Scalar COUNT(*) Aggregate on JOIN
- RELEASE
- ParadeDB Release Process
- avl
- avl
- README
- TopK Aggregate on JOIN (DataFusion)
- README
- Semi-Join Filter (Term Set)
- README
- TopK Score DESC, High Selectivity (Single Table, BM25)
- README
- PostgreSQL Regression Tests for ParadeDB
- README
- bucket_string_nofilter
- README
- Aggregate Sort (Computed Property)
- README
- Date Histogram on JOIN
- README
- Test suite for pg_search
- README
- TopK Score DESC with Range Filter, Medium Selectivity (Single Table, BM25)
- README
- Diagnosing Quantized Vector Indexes
- README
- Stack Overflow Benchmark Suite
- README
- bucket_string_filter
- README
- ParadeDB Dockerfiles
- README
- count_filter
- README
- bucket_numeric_nofilter
- README
- TopK Score DESC with Range Filter, High Selectivity (Single Table, BM25)
- SECURITY
- Security Policy
- README
- Distinct Parent Sort (Join Explosion)
- CODE_OF_CONDUCT
- Contributor Covenant Code of Conduct
- CHANGELOG
- ParadeDB Changelog
- README
- Conjunctive Search across Normalized Hierarchy (Score Sort)
- README
- Disjunctive Search across Normalized Hierarchy (Score Sort)
- README
- TopK Score DESC, Medium Selectivity (Single Table, BM25)
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.