Roadmap

​

In Progress

​

JOIN Improvements

• Join pushdown (beta). Join pushdown is available for INNER, SEMI, and ANTI joins, pushing search predicates directly into the index for significantly better performance.
• Scoring and highlighting across JOINs. BM25 score and snippet functions can be used in JOIN queries.
• Smarter JOIN planning for search indexes. Apply index-aware optimizations and cost estimation strategies when multiple BM25-indexed tables are joined.
• More join types for pushdown. Extending pushdown support to LEFT, RIGHT, FULL OUTER, CROSS, and LATERAL joins.

​

Ecosystem Integrations

• ORMs. Official support for more ORMs, like Prisma and others, is coming. Django, Rails, and SQLAlchemy are already available.
• AI Frameworks. Official support for LangChain, LLamaIndex, CrewAI, and others are coming.
• PaaS Providers. Official tutorials for hosting ParadeDB on more platform-as-a-service providers like Porter.run and others is coming. Railway, Render, and DigitalOcean are already available.

​

Long Term

​

Deeper Analytics Improvements

• Push Postgres visibility rules into the index. This is currently a filter applied post index scan that adds overhead to large scans.
• Parallel aggregate execution. Aggregate pushdown across joins currently runs single-threaded. Two-phase parallel aggregation (partial + final) will unlock multi-core execution for high-cardinality GROUP BY on joined tables.

​

Vector Search Improvements

• Improve vector search performance in Postgres by addressing pgvector’s limitations around filtered queries — specifically, queries that combine vector similarity with metadata filters or full-text search predicates.

​

Managed Cloud

• Today, you can deploy ParadeDB self-hosted, on cloud platforms, or with ParadeDB BYOC. We are working on a fully managed cloud offering, with a focus on scalability and supporting distributed workloads.

​

Completed

​

Analytics

• A custom scan node for aggregates. Plain SQL aggregates like COUNT, and clauses like GROUP BY, go through the same fast execution path as our aggregate UDFs.
• Aggregate pushdown across joins. Aggregates over multi-table joins are pushed down into the index when every joined table has a BM25 index.

​

Write Throughput

• Background merging. Improves write performance by merging index segments asynchronously without blocking inserts.
• Pending list. Buffers recent write before flushing them to the LSM tree.

​

Improved UX

• More intuitive index configuration. Overhaul the complicated JSON WITH index options.
• More ORM friendly. Overhaul the query builder functions to use actual column references instead of string literals.
• New operators. In addition to the existing @@@ operator, introduce new operators for different query types (e.g. phrase, term, conjunction/disjunction).

​

We’re Hiring