Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt

Use this file to discover all available pages before exploring further.

This page is for developers who are evaluating or actively migrating from Elasticsearch (or OpenSearch) to ParadeDB. ParadeDB delivers Elastic-quality full-text search as a Postgres extension, so your data, queries, and infrastructure all live inside Postgres — no ETL pipelines, no separate cluster to manage.

​
Key Differences

ElasticsearchParadeDB
Query languageJSON DSLStandard SQL with search operators
Data modelDenormalized documentsNormalized relational tables with JOINs
TransactionsPer-document atomicity, eventual consistencyFull ACID transactions
Index storageSeparate clusterInside Postgres (same database)
Schema changesDynamic mapping or reindexDefined at index creation; REINDEX to change
Updates/deletesExpensive (reindex internally)Native Postgres operations

​
Migration Tips

  • Start with your most common queries. Map your highest-traffic Elasticsearch queries using the full-text search reference.
  • Use SQL JOINs instead of denormalization. Elasticsearch requires denormalized documents, but ParadeDB supports full SQL JOINs. You can normalize your schema and simplify your data model.
  • Continue to use Postgres tooling. Backups, replication, monitoring, and CI/CD integrate with standard Postgres tools you already use.

​
Feature Comparison

​
Query Capabilities

FeatureElasticsearchParadeDBNotes
Full-text search (BM25)✅✅Match and phrase operators
Fuzzy matching✅✅Max edit distance of 2 via pdb.fuzzy()
Phrase matching✅✅### operator
Phrase prefix✅✅pdb.phrase_prefix()
Regular expressions✅✅pdb.regex()
Wildcard queries✅✅Via regex
Boolean queries✅✅Via SQL AND/OR/NOT or paradedb.boolean
Proximity search✅✅## operator
More Like This✅✅paradedb.more_like_this
Nested queries✅✅Via SQL JOINs
Parent-child queries✅✅Via SQL JOINs
Geo queries✅❌Use PostGIS
Percolator (reverse search)✅❌
Script-based scoring✅❌
Suggesters (autocomplete)✅✅Via search_tokenizer (index with ngram, search with unicode) or fuzzy prefix

​
Text Analysis

FeatureElasticsearchParadeDBNotes
Custom tokenizers✅✅12+ built-in tokenizers
Token filters✅✅7 filters: lowercase, stemmer, stopwords, ascii_folding, alpha_num_only, trim, token_length
Character filters✅❌
Synonyms✅⚠️Coming soon
Different search-time analyzer✅✅Via search_tokenizer or multiple tokenizers per field
Multi-language support✅✅Chinese (Jieba), Japanese/Korean (Lindera), ICU
Stemming✅✅19 languages
Stopwords✅✅29 languages
N-gram tokenization✅✅Configurable min/max gram size

​
Aggregations

FeatureElasticsearchParadeDBNotes
Bucket aggregations✅✅terms, histogram, date_histogram, range, filters
Metric aggregations✅✅avg, sum, min/max, count, stats, percentiles, cardinality, top_hits
Pipeline aggregations✅✅Use SQL window functions (SUM() OVER(), LAG(), etc.)
Nested aggregations✅✅Use pdb.agg() with SQL GROUP BY
ES-compatible JSON syntax—✅pdb.agg() accepts ES JSON directly
SQL GROUP BYLimited✅Full SQL aggregation support
Since pdb.agg() accepts Elasticsearch-compatible JSON, many of your existing aggregation queries can be migrated with minimal changes. See the aggregates documentation.

​
Scoring and Relevance

FeatureElasticsearchParadeDBNotes
BM25 scoring✅✅pdb.score()
Custom boost✅✅pdb.boost() type cast
Constant score✅✅pdb.const()
Disjunction max✅✅paradedb.disjunction_max()
Function score✅❌Use boost / const as partial alternatives
Script scoring✅❌
Decay functions✅❌
Field value factor✅❌

​
Highlighting

FeatureElasticsearchParadeDBNotes
Snippet highlighting✅✅pdb.snippet()
Multiple snippets✅✅pdb.snippets()
Custom tags✅✅start_tag, end_tag parameters
Byte offsets❌✅pdb.snippet_positions()
Fuzzy highlighting✅❌

​
Index Management

FeatureElasticsearchParadeDBNotes
Create index✅✅CREATE INDEX ... USING bm25
Drop index✅✅DROP INDEX
Reindex✅✅REINDEX
Index aliases✅✅Via Postgres views
Index templates✅❌
Dynamic mapping✅❌Schema defined at index creation; requires REINDEX to change
Multi-field index✅✅All columns included in one index per table

​
Data Operations

FeatureElasticsearchParadeDBNotes
ACID transactions❌✅Full Postgres ACID compliance
Real-time indexing⚠️✅ES is near-real-time (requires refresh); ParadeDB provides immediate read-after-write
JOINs❌✅Full SQL JOIN support
UPDATE / DELETE⚠️✅ES internally reindexes; Postgres handles natively
Bulk insert✅✅COPY or batch INSERT
SQL queries❌✅Full SQL including subqueries, CTEs, window functions

​
Deployment and Operations

FeatureElasticsearchParadeDBNotes
Horizontal sharding✅⚠️Via Citus for distributed workloads
Read replicas✅✅Postgres streaming replication
Kubernetes✅✅CNPG / Helm charts
Docker✅✅Official Docker image
Logical replication ingest❌✅Sync from existing Postgres
Cross-cluster search✅❌
Snapshot / restore✅✅Via Postgres backup tools (pg_dump, WAL archiving)
Monitoring✅✅pg_stat, pganalyze, standard Postgres tools

​
Pagination

FeatureElasticsearchParadeDBNotes
from / size✅✅SQL LIMIT / OFFSET
scroll API✅❌Use SQL cursors (DECLARE / FETCH) instead
search_after✅❌Use keyset pagination (WHERE id > last_id ORDER BY id) instead
Top K optimization✅✅paradedb.limit_fetch_multiplier