Physical replication and failover on ParadeDB Community
High availability and read replicas have always been ParadeDB Enterprise features, but previously spinning up a physical standby on ParadeDB Community stopped WAL replay entirely when a ParadeDB index was created (#6007). Physical replication is now allowed to continue: non-ParadeDB queries work normally, queries that use a ParadeDB index on a read replica return an error, and if a standby fails over to become a primary (or a server is restored from a base backup taken on a standby) its replicated ParadeDB indexes emit an error and require REINDEX INDEX. Backups taken from the primary are unaffected.Upgrade standbys before the primary: the primary now writes a ParadeDB WAL record during CREATE INDEX, VACUUM, and ANALYZE on indexed tables, and a standby running an earlier release shuts down when replaying that record.
Other Changes
Adding a vector to an L2 (vector_l2_ops) or inner-product (vector_ip_ops) field of a ParadeDB index now fails when the vector’s magnitude (its length from the origin) is above about 6.5e18, and searching such a field with a query vector above that magnitude fails too. Vectors that large overflowed the index’s single-precision arithmetic. Cosine fields accept any finite vector. Vectors already in an index are not re-checked, but REINDEX of an index holding one fails.
Direct indexing of ltree columns in ParadeDB indexes (USING paradedb (..., path)) is now deprecated with a create-time warning and will be removed in a future release. Users should create a standard PostgreSQL GiST index on the ltree column alongside the ParadeDB index (USING gist (path)), which is automatically intersected with ParadeDB searches via bitmap intersection while supporting the full set of ltree operators (<@, @>, ~, ?, @).
Whole-row searches no longer implicitly target the index’s key field. A bare query such as t @@@ 'shoes'
now searches across indexed fields. Field-specific builders such as t @@@ pdb.term('shoes') now raise an
error; use an indexed column instead, for example t.description @@@ pdb.term('shoes') or
t.description === 'shoes'. Whole-row pdb.all(), pdb.empty(), and pdb.parse() queries remain supported,
including score adjustments.
Replaced the vector_fields JSON index option with quantization, which applies to every vector field. It defaults to '[1,1]'. Use quantization = 0 to disable quantization or an array such as '[1,4]' to choose layer widths. Recreate indexes that explicitly store vector_fields using the new option.
paradedb.mpp_queue_size now specifies the per-query DSM byte budget across all SPSC rings in an MPP mesh (default 8MB, accepting standard PostgreSQL byte units such as '8MB' or '64MB') rather than a message count. The paradedb.mpp_request_timeout GUC has been removed now that MPP stages stream over event-driven gRPC channels in shared memory.
Removed per-cluster radius pruning and its build, storage, and query costs from IVF vector indexes. Existing IVF indexes require REINDEX. paradedb.vector_clusters now returns only segno and cluster_sizes; radius-related EXPLAIN counters have also been removed.
Quantized IVF vector segments store their full-precision rows in document order in an entry of their own, so each cluster block carries document IDs and quantized columns only. Exact scoring reads one row per admitted document from that entry. The .vec format moves to version 6; existing vector indexes require REINDEX.
Renamed the IVF index option max_leaf_size to target_leaf_size. The value is the target number of indexed vectors per clustering leaf. Training scales it by training_sample_ratio; it does not cap the number of indexed vectors assigned to a cluster. Indexes that explicitly store max_leaf_size must be updated with ALTER INDEX ... SET (target_leaf_size = ...) or recreated.
Term sets in a query (pdb.term_set, === with an array, or IN (...) / = ANY(...) on an indexed field) are now capped by the new paradedb.max_term_set_size setting, which defaults to 262144 terms. Queries over the limit raise an error, and queries over half the limit emit a warning. Very large term sets are better written as a join; if that is not possible, raise paradedb.max_term_set_size.
Prebuilt pg_search binary packages now require PostgreSQL 15.20, 16.16, 17.12, or 18.7 (or newer within each major series) because CVE-2026-6460 moved DatumGetHeapTupleHeader out of line into the server binary. Upgrade PostgreSQL to at least those point releases before installing or upgrading prebuilt pg_search packages; building from source continues to support earlier point releases.
New Features ✨
Set training_sample_ratio = 0 to automatically size the vector training sample based on available memory. The default remains 0.32 (32%).
Search predicates combined with an OR of indexable conditions now intersect a BitmapOr of those conditions’ indexes, rejecting non matching rows without a heap fetch.
paradedb.vector_info reports each IVF segment’s router in vector_router and the number of centroids at each router level, bottom to top, in vector_router_levels.
Vector indexes default to replication = 2: each vector of a quantized IVF field is also assigned to a second cluster chosen to cover queries its first cluster misses. Replication roughly doubles the quantized rows scanned per opened cluster and the index build time, and adds about one quantized row per vector to the index; full-precision rows are not duplicated. It applies to newly clustered segments. Set replication = 1 to disable the second assignment.
Match, phrase and query parser queries expand with synonym rules that you keep in a table. Give the rules to |||, &&&, ### or @@@ with a subquery, as in description ||| (SELECT pdb.expand('sofa', rule) FROM shop_synonyms). A change to the rules applies on the next query with no reindex. See Synonyms.
pdb.explain_score(<column>) explains the BM25 score of a row as jsonb, with the idf, the frequency and the field length of each term that the row matches. A synonym group explains as one term and lists the words of the group that the row holds. See Score Explanation.
Performance Improvements 🚀
Global vector routing
paradedb.vector_cluster_max_probe now sets an absolute work budget in average-cluster units, accepting whole numbers from 1 through 100000 with a default of 100. Opening clusters and scoring rows consume the same cost-based budget; selective filters can visit more clusters. Update existing values to the desired absolute budget.
Other Changes
Sign-quantized vector scans run faster on CPUs with AVX-512 VPOPCNTDQ (Intel Ice Lake-SP and later, AMD Zen 4 and later). Scores and the index format are unchanged.
Set the default IVF target_leaf_size to 400 indexed vectors per leaf. Existing clusters and explicit target_leaf_size settings are unchanged.
Vector searches reuse prepared query data across centroid routing and exact reranking and read centroids in batches, reducing repeated computation and storage reads.
Stacked IVF list selection now scales with the number of clusters a query asks to probe, so every stacked IVF index can see different recall and latency. The probe stops only on the work budget (paradedb.vector_cluster_max_probe) or when the ranking runs out. L2 and cosine indexes at 128 dimensions or fewer also no longer stop early through geometry-based adaptive partition scanning. paradedb.vector_router_recall_target and paradedb.vector_recall_target remain accepted and have no effect.
Vector routing stops after five quiet clusters instead of a short row budget, so a single large cluster no longer ends the probe early.
Vector ORDER BY searches share a top-k pruning threshold across segments and parallel workers on the same query, so later segments can cut work using scores already found elsewhere.
Vector index builds run faster. Each vector’s second (replica) cluster comes from the nearest-centroid pass and the centroids’ Gram matrix instead of a second pass over every centroid, and a quantized segment encodes its clusters in parallel. On x86 CPUs with AVX2 and FMA, and with SSE4.1, quantized scoring and query preparation use those instructions instead of math-library calls. Quantized encoding and scoring are unchanged bit for bit; replica clusters can differ where two candidates tie to floating-point rounding.
Faster vector index builds and query preparation with quantization (the default), using branch-free encoding everywhere and SIMD kernels on x86. Encoded rows and search results are unchanged.
Aggregate Scan now answers COUNT(col) ... GROUP BY col for text, boolean and JSON columns from each group’s document count instead of computing a separate metric, which speeds up grouped counts such as SELECT name, COUNT(name) ... GROUP BY name (#6707).
Added adaptive stopping for vector cluster probing. paradedb.vector_cluster_max_probe continues to control the router request and probe-work ceiling; paradedb.vector_adaptive_probing allows the scan to stop sooner when competitive-candidate admission decays.
Vector indexes quantize the IVF router by default: new segments route each query through one-bit codes of the centroids and rerank the shortlisted centroids exactly. vector_router_quantization = false keeps full-precision routing; segments keep the router they were clustered with until the index is rebuilt.
Vector searches do less work per scanned row on replicated IVF indexes (the default replication = 2): clusters whose rows an earlier cluster already holds are scored through the batch kernels and decoders, read planning skips pricing sparse reads that cannot beat a whole-cluster read, and each cluster’s storage block is looked up fewer times. Results and the index format are unchanged.
Fuzzy matches (||| 'x'::pdb.fuzzy(1), pdb.match('x', distance => 1)) plan as fast as pdb.fuzzy_term. The planner uses its selectivity heuristic for them instead of building the fuzzy automaton, so their row estimate becomes a fixed fraction of the table. paradedb.enable_heuristic_selectivity = off gives the estimate from the index.
Vector ORDER BY searches cost less per query. The plan carries the query vector once, in a compact form, instead of twice as a list of numbers; per-segment scan statistics are built only when EXPLAIN ANALYZE or paradedb.vector_stats shows them; and the exact phase scores the most promising candidates first, so fewer of the rest are read and scored. Because that order changes which candidates near the cutoff are dropped, a top-k result can differ in rare cases. Planning a query that matches every row, such as @@@ paradedb.all(), on an index without a WHERE predicate estimates its selectivity and segment count without opening the index, so the planner’s row estimate for it is the table’s row count. Index page reads first try the shared buffer that last held the page and fall back to the usual buffer lookup. The index format is unchanged.
Range filters (<, <=, >, >=, BETWEEN, and pdb.range) now produce more accurate row estimates on skewed columns, and joins with query parameters ($1) or subqueries refine their estimates once parameter values are bound. Selective ORDER BY ... LIMIT joins (ordered by search score, vector distance, or an indexed column) use these estimates to push matching join keys directly into the search or vector index instead of scanning past non-matching rows.
Stability Improvements 💪
Fixed pdb.parse() queries on NUMERIC fields that returned wrong rows, no rows, or parse errors. Literals, ranges, and sets use exact comparisons, and invalid input follows strict or lenient parsing rules (#6105).
Range-partitioned parallel joins on NUMERIC columns no longer skew every row into the first partition, and no longer fail for NUMERIC columns without a precision.
NUMERIC columns declared with a scale outside -18 to 18, such as numeric(3,20), can now be indexed. They used to fail with an error ending in exceeds maximum 18 for Decimal64NoScale, either at CREATE INDEX or on the first search after a row was inserted. An index created on an earlier version keeps its previous layout for such a column and still fails this way, so run REINDEX on any index that hit this error.
A search read now takes a predicate lock under SERIALIZABLE. Without it, two transactions could each count the rows matching a search, then each insert a matching row, and both commit, while Postgres’ own plans for the same read abort one of them (#6390). The lock covers the whole table, so a write from another SERIALIZABLE transaction creates a dependency with the read even when it touches a row the search did not match.
A LIMIT query over a bitmap intersection no longer fails with “bitmap intersection stream … claimed twice” when it has to search again, for example after deleted rows hid its first batch, or when a window aggregate runs alongside it (#6403).
Fixed a search operator in the SELECT list, such as title ||| 'alpha', being charged paradedb.per_tuple_cost. The inflated cost pushed small queries past the JIT thresholds and made them much slower (#6406).
A heap filter that calls an allocating function, such as tags @> jsonb_build_array('x'), no longer grows the backend’s memory with every row it rejects (#6739).
Fixed JoinScan returning NULL for selected system columns (ctid, tableoid, xmin, cmin, xmax, and cmax). Matched rows now return the system attributes of the fetched heap tuple; unmatched outer-join rows still return NULL.
Construct operator function expressions through PostgreSQL’s node constructor so additional server-defined fields do not cause missing-field initializer errors.
Filters that compare a NUMERIC(p, s) column with p of 18 or less to a literal carrying more decimal places than s, such as price = 10.005 on a numeric(10,2) column, now return the same rows as PostgreSQL. The pushed-down query used to round the literal to the column’s scale first, so equality, IN and range filters could match the wrong rows. Comparing the column with a very large literal, such as price > 1e17, no longer raises an error.
NOT (field @@@ <expr>) no longer returns every row when <expr> evaluates to NULL.
Fixed paradedb.planner_warnings so runtime scan, spill, and visibility-map diagnostics honor off and error, EXPLAIN ANALYZE enforces error mode, and changing the setting invalidates cached plans.
Fixed incorrect DISTINCT and GROUP BY results for array columns and expressions over them, including slices, subscripts, and domain casts. These queries now use PostgreSQL aggregation to preserve empty arrays, NULL elements, dimensions, and lower bounds.
Fixed COUNT(array_column) and COUNT(array_column) OVER () counting array elements instead of non-NULL rows, including empty arrays and arrays containing only NULLs.
Filters on ctid or tableoid that ParadeDB evaluates against the heap, such as b.ctid > '(0,2)' on a Join Scan source, now return the same rows as PostgreSQL. The filter used to compare an invalid ctid and a zero tableoid, so it matched every row or none.
Integer +, - and * in expressions evaluated by the Join Scan now raise an out-of-range error on overflow instead of silently wrapping.
Float division by zero in expressions evaluated by the Join Scan now raises division by zero instead of returning Infinity.
sum() over a bigint column in an aggregate over a join now returns the exact total instead of silently wrapping on overflow.
remove_short and remove_long now measure tokens after trim=true removes their surrounding whitespace. Reindex existing indexes that combine trim=true with either length filter to make previously indexed values consistent with queries and new writes. Existing indexes remain usable without reindexing, but affected values may return different or incomplete results.
The JSONB ? operator now matches PostgreSQL in a ParadeDB scan, including string elements of a top-level array, a top-level string scalar, keys with a null value, and keys that contain a dot.
sum() over a bigint column in a single-table aggregate now returns the exact total instead of rounding values past 2^53.
Fixed join filters over NUMERIC columns in the aggregate scan and JoinScan, which read the stored scaled values and could return wrong results or fail. For example, comparing numeric(10,2) with numeric(10,3), or floor(a.amt) <> b.amt, now matches PostgreSQL.
Fixed precision loss in numeric constants used by pushed-down aggregate HAVING and FILTER comparisons.
paradedb.range() on a JSON numeric path no longer matches fractional values outside an integer bound, such as [5,5] matching 5.5.
ORDER BY ... LIMIT with FOR UPDATE SKIP LOCKED no longer returns fewer rows than the limit when the top-ranked rows are locked by another transaction.
Fixed an unrecognized node type error when using pdb.score() inside arithmetic or text expressions in join predicates and aggregate filters.
Fixed an internal error in filters comparing a real or double precision column with NaN, Infinity or -Infinity.
Stopwords (stopwords_language and stopwords) are now removed before stemming and ASCII folding. Previously, a transformed stopword could be indexed, such as Spanish para stemmed to par. Existing indexes that combine stopwords with stemming or ASCII folding remain usable, but searches can miss matches or return extra matches because older rows were indexed with the previous filter order. Run REINDEX on affected indexes to make results consistent across existing rows and new writes.
Fixed IVF target_leaf_size so it describes the desired full-dataset leaf size. Training now scales it by training_sample_ratio (the default 400 trains at 128) so final clusters stay near the configured target. Existing indexes are unaffected until they are rebuilt.
Queries that run as an Aggregate Scan or Join Scan no longer crash the backend when auto_explain logs their plan without log_analyze.
PL/pgSQL variables used as LIMIT/OFFSET, as pdb.snippet() arguments, or as a vector ORDER BY operand now keep their values once the statement switches to a generic plan, instead of returning wrong rows or crashing the backend.
Under SERIALIZABLE, an aggregate that runs with MPP no longer misses an INSERT that commits after the query starts but before it reads the index. Both transactions could commit with write skew (#7428).
A query that negates a fuzzy or regex clause next to another filter, such as lang === 'ja' AND NOT (title === 'x'::pdb.fuzzy(1)), gets its row estimate from the index. The planner used to plan it as one row.
Fixed Join Scans restarting from the first row on each cursor fetch, which could cause PL/pgSQL FOR loops to run indefinitely. Fixed cursors over DataFusion Aggregate Scans stopping after the first 8192 groups.
Align parallel JoinScan, AggregateScan, and BaseScan execution with PostgreSQL’s parallel_leader_participation GUC, per-table parallel_workers reloption, and parallel-mode safety rules (TEMP tables, PARALLEL RESTRICTED expressions, and partial cursor/portal fetches).
Reject negative slop values in pdb.phrase and pdb.regex_phrase instead of matching terms farther apart than intended.
pdb.agg() over a join now reads a column indexed inside a composite type, such as ROW(category)::item_fields, instead of failing with Field 'category' is an expression index, which cannot be read back as a column.
Reject negative max_expansion values in pdb.phrase_prefix instead of converting them to large unsigned limits.
@@@ no longer fails with an internal error for a pdb.query value known only at run time, such as a subquery or a parameter of a generic plan.
A phrase query keeps the positions of its tokens. So ### finds sofa of leather on a field that removes stop words, and it matches a word on a pdb.edge_ngram field.
A configuration reload during a Join Scan or Aggregate Scan query that runs with MPP workers no longer fails the query with parameter ... cannot be set during a parallel operation.
Was this page helpful?
{"docsConfig":{"theme":"aspen","$schema":"https://mintlify.com/docs.json","name":"ParadeDB","colors":{"primary":"#4f46e5","light":"#4f46e5","dark":"#818cf8"},"logo":{"light":"https://mintcdn.com/paradedb/X75hU2Xqk72Fhmya/logo/light.svg?fit=max\u0026auto=format\u0026n=X75hU2Xqk72Fhmya\u0026q=85\u0026s=ac5ce043daf4c85d48b56bcd7f69c14f","dark":"https://mintcdn.com/paradedb/X75hU2Xqk72Fhmya/logo/dark.svg?fit=max\u0026auto=format\u0026n=X75hU2Xqk72Fhmya\u0026q=85\u0026s=2750fde357923cc6615d68f74451aa1e","href":"https://www.paradedb.com"},"favicon":"https://mintcdn.com/paradedb/EnFi_28R6H66KMiU/favicon.png?fit=max\u0026auto=format\u0026n=EnFi_28R6H66KMiU\u0026q=85\u0026s=f066fc45b5ff39c3b46b210cbcbb5a06","appearance":{"strict":false},"navbar":{"links":[{"href":"https://github.com/paradedb/paradedb","type":"github"},{"href":"https://app.paradedb.com","label":"Log In"}],"primary":{"type":"button","label":"Sign Up","href":"https://auth.paradedb.com/sign-up"}},"footer":{"socials":{"github":"https://github.com/paradedb/paradedb","twitter":"https://x.com/paradedb","linkedin":"https://www.linkedin.com/company/paradedb","slack":"https://paradedb.com/slack"}},"seo":{"metatags":{"charset":"UTF-8","viewport":"width=device-width, initial-scale=1.0","keywords":"paradedb, postgres, search, analytics, bm25, full-text search, vector search, semantic search, hybrid search, faceted search, columnar, olap","author":"ParadeDB","google":"notranslate","generator":"Mintlify","theme-color":"#000000","color-scheme":"light dark","referrer":"origin","rating":"general","revisit-after":"7 days","language":"en","copyright":"ParadeDB, Inc. 2026","reply-to":"support@paradedb.com","distribution":"global","coverage":"Worldwide","category":"Technology","target":"all","HandheldFriendly":"True","MobileOptimized":"320","apple-mobile-web-app-capable":"yes","apple-mobile-web-app-status-bar-style":"black","apple-mobile-web-app-title":"ParadeDB Docs","og:type":"website","og:locale":"en_US","og:description":"You should just use Postgres.","og:image":"https://www.paradedb.com/opengraph-image.png","og:image:alt":"ParadeDB: Just use Postgres","twitter:card":"summary_large_image","twitter:site":"@paradedb","twitter:creator":"@paradedb","twitter:description":"You should just use Postgres.","twitter:image":"https://www.paradedb.com/twitter-image.png","twitter:image:alt":"ParadeDB: Just use Postgres"},"indexing":"navigable"},"banner":{"content":"[ParadeDB Cloud is now available in private preview](https://auth.paradedb.com/sign-up)","dismissible":false},"contextual":{"options":["copy","mcp","cursor","vscode","perplexity","chatgpt","claude",{"title":"Share on X","description":"Share this page on X","icon":"x","href":{"base":"https://x.com/intent/tweet","query":[{"key":"text","value":"Check out this ParadeDB doc!"},{"key":"url","value":"https://www.paradedb.com/docs$path"}]}}],"display":"header"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"paradedb","hasAudioNarration":false,"actualSubdomain":"paradedb","customDomains":["www.paradedb.com"],"gitSource":{"type":"github","owner":"paradedb","repo":"paradedb","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true,"edits":true},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6afe9a38be38cd8ab057a1ee","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"Reference","count":85},{"language":"default","tag":"Full-Text / Lexical Search","count":46},{"language":"default","tag":"Operate","count":27},{"language":"default","tag":"Text Analysis","count":25},{"language":"default","tag":"Aggregations","count":16},{"language":"default","tag":"Query Types","count":13},{"language":"default","tag":"Tokenizers","count":13},{"language":"default","tag":"Indexing","count":12},{"language":"default","tag":"Deployment","count":10},{"language":"default","tag":"Metrics","count":8}]},"assistantConfig":{},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"#search-bar-entry{visibility:visible}#banner{background-color:#4f46e5!important;background-image:none!important;border-bottom:0!important;display:flex;height:2.75rem!important;max-height:none!important;min-height:2.75rem;padding:0!important}@media (min-width: 640px){#banner{height:3rem!important;min-height:3rem}}#banner>div{align-items:center;backdrop-filter:blur(12px);background-color:rgb(255 255 255 / 10%);border-bottom:1px solid rgb(255 255 255 / 20%)!important;box-shadow:inset 0 -1px rgb(255 255 255 / 20%);display:flex;justify-content:center;box-sizing:border-box;height:100%;margin:0!important;padding:0.75rem 1rem;width:100%}#banner p{display:inline-flex;align-items:center;justify-content:center;gap:0.5rem;height:100%;margin:0!important;max-width:100%;min-width:0;font-size:0.75rem;line-height:1rem}#banner a{color:#ffffff!important;display:inline-flex;align-items:center;font-size:inherit;font-weight:500;gap:0.5rem;line-height:inherit;text-decoration:none}#banner a:hover{color:#ffffff!important}#banner a::after{content:\"->\";display:inline-block;flex:none;transition:transform 160ms ease}#banner a:hover::after{transform:translateX(2px)}#banner .banner-badge{display:none;flex:none;background-color:rgb(255 255 255 / 10%);padding:0.25rem 0.625rem;font-size:0.625rem;font-weight:600;line-height:1;text-transform:uppercase}@media (min-width: 640px){#banner p{font-size:0.875rem;line-height:1.25rem}#banner .banner-badge{display:inline-flex;font-size:0.75rem}}.topbar-right-container nav ul{gap:1.25rem!important}.navbar-link>a{background:transparent!important;border-radius:0!important;color:rgb(30 41 59 / 85%)!important;font-size:0.875rem!important;line-height:1.25rem!important;padding:0.25rem 0.125rem!important;transition:color 160ms ease}.navbar-link>a:hover{background:transparent!important;color:#4f46e5!important}.dark .navbar-link>a{color:rgb(255 255 255 / 86%)!important}.dark .navbar-link>a:hover{color:#ffffff!important}img.nav-logo{height:2rem!important}a.nav-tabs-item{font-size:1.0625rem!important}a.nav-tabs-item span[class*=\"h-4\"]{height:1.25rem!important;width:1.25rem!important}.card{border-radius:0!important}#pagination>a{border:0;border-radius:0}.architecture-diagram{--architecture-node-inset: 18px;--architecture-surface: #ffffff;--architecture-background: #f9fafc;--architecture-border: #dfe3eb;--architecture-text: #1e293b;--architecture-muted: #606d82;--architecture-line: #99a3b5;--architecture-accent: #4f46e5;--architecture-accent-soft: #eeedff;--architecture-index: #f6f5ff;--architecture-index-border: #ccc9f3;--architecture-divider: #e0def4;--architecture-shadow:\n 0 1px 2px rgb(30 27 75 / 4%), 0 4px 12px rgb(30 27 75 / 3%);container-type:inline-size;margin:2.5rem 0;color:var(--architecture-text);font-size:14px;line-height:1.5}.dark .architecture-diagram{--architecture-surface: #17171e;--architecture-background: #101015;--architecture-border: #30303c;--architecture-text: #ececf3;--architecture-muted: #a6a6b9;--architecture-line: #73738c;--architecture-accent-soft: #202028;--architecture-index: var(--architecture-surface);--architecture-index-border: #3e3e4b;--architecture-divider: var(--architecture-border);--architecture-shadow: 0 1px 2px rgb(0 0 0 / 12%), 0 4px 12px rgb(0 0 0 / 8%)}.architecture-diagram svg{display:block;flex:none;stroke-linecap:round;stroke-linejoin:miter}.architecture-app{display:flex;align-items:center;justify-content:center;gap:10px;width:fit-content;margin:0 auto;padding:11px 20px;border:1px solid var(--architecture-border);border-radius:0;background:var(--architecture-surface);box-shadow:var(--architecture-shadow);font-weight:500}.architecture-app svg,.architecture-heading svg{width:22px;height:22px}.architecture-connection{position:relative;display:flex;justify-content:center;height:48px;color:var(--architecture-line)}.architecture-connection svg{width:16px;height:48px}.architecture-connection span{position:absolute;top:50%;transform:translateY(-50%);color:var(--architecture-muted);font-size:12px}.architecture-sql span{left:calc(50% + 14px);font-family:ui-monospace, SFMono-Regular, Menlo, monospace;font-size:12px;letter-spacing:0.04em}.architecture-postgres{padding:22px;border:1px solid var(--architecture-border);border-radius:0;background:var(--architecture-background)}.architecture-database-heading,.architecture-index-heading{display:flex;align-items:center;justify-content:space-between;gap:12px}.architecture-database-heading{margin-bottom:22px}.architecture-heading{display:flex;align-items:center;gap:10px;font-size:16px;font-weight:600;letter-spacing:-0.02em}.architecture-database-heading svg{width:1em;height:1em}.architecture-table{display:flex;align-items:center;gap:12px;padding:17px var(--architecture-node-inset);border:1px solid var(--architecture-border);border-radius:0;background:var(--architecture-surface);box-shadow:var(--architecture-shadow)}.architecture-table-icon{width:28px;height:28px;color:var(--architecture-muted)}.architecture-title{font-size:14px;font-weight:600}.architecture-detail{margin-top:4px;color:var(--architecture-muted);font-size:12px;text-wrap:balance}.architecture-writes{justify-content:flex-start;padding-left:calc(var(--architecture-node-inset) + 7px)}.architecture-writes span{left:calc(var(--architecture-node-inset) + 41px)}.architecture-index{overflow:hidden;border:1px solid var(--architecture-index-border);border-radius:0;background:var(--architecture-index);box-shadow:var(--architecture-shadow)}.architecture-index-heading{padding:17px var(--architecture-node-inset);border-bottom:1px solid var(--architecture-divider)}.architecture-index-heading .architecture-heading{gap:12px}.architecture-heading .architecture-brand{width:22px;height:22px;margin:3px;color:var(--architecture-accent)}.architecture-extension{flex:none;padding:3px 7px;border:1px solid var(--architecture-divider);border-radius:0;background:var(--architecture-accent-soft);color:var(--architecture-text);font-family:ui-monospace, SFMono-Regular, Menlo, monospace;font-size:11px}.architecture-structures{display:grid;grid-template-columns:repeat(3, minmax(0, 1fr));padding:24px 0 22px}.architecture-structure{padding:0 6px;text-align:center}.architecture-structure+.architecture-structure{border-left:1px solid var(--architecture-divider)}.architecture-structure svg{width:56px;height:40px;margin:0 auto 14px;color:var(--architecture-accent)}@container (max-width: 380px){.architecture-postgres{--architecture-node-inset: 14px;padding:16px}.architecture-table{padding-block:15px}.architecture-index-heading{flex-wrap:wrap;gap:6px 12px;padding-block:15px}.architecture-structures{grid-template-columns:1fr;padding:0 14px}.architecture-structure{display:grid;grid-template-columns:48px 1fr;column-gap:16px;padding:14px 0;text-align:left}.architecture-structure+.architecture-structure{border-top:1px solid var(--architecture-divider);border-left:0}.architecture-structure svg{grid-row:span 2;align-self:center;width:48px;height:32px;margin:0}}@container (max-width: 320px){.architecture-index-heading{flex-direction:column;align-items:flex-start}.architecture-extension{margin-left:40px}}.architecture-detail-diagram .architecture-svg{width:100%;height:auto;font-family:inherit;font-size:17px;fill:var(--architecture-text)}.architecture-svg-boundary{fill:var(--architecture-background);stroke:var(--architecture-border)}.architecture-svg-surface{fill:var(--architecture-surface);stroke:var(--architecture-border)}.architecture-svg-index{fill:var(--architecture-index);stroke:var(--architecture-index-border)}.architecture-svg-line{fill:none;stroke:var(--architecture-line);stroke-width:1.5}.architecture-svg-rule{fill:none;stroke:var(--architecture-border)}.architecture-svg-title{font-size:18px;font-weight:600;letter-spacing:-0.02em}.architecture-svg-label{fill:var(--architecture-muted);font-size:14px}.architecture-svg-stage-title{font-size:17px;font-weight:600}.architecture-svg-small{font-size:13px}.architecture-detail-diagram .architecture-svg-compact{display:none}@container (max-width: 420px){.architecture-detail-diagram .architecture-svg-wide{display:none}.architecture-detail-diagram .architecture-svg-compact{display:block;max-width:380px;margin:0 auto}}"},{"filePath":"cookie-consent.css","content":"#paradedb-cookie-banner{position:fixed;inset-inline:0;bottom:0;z-index:9999;display:flex;flex-direction:column;align-items:flex-start;justify-content:space-between;gap:0.75rem;padding:1rem 1.5rem;color:oklch(44.6% 0.043 257.281);background:rgb(255 255 255 / 95%);border-top:1px solid oklch(92.9% 0.013 255.508);backdrop-filter:blur(8px);font-size:0.75rem;line-height:1.625}#paradedb-cookie-banner p{margin:0;min-width:0;max-width:56rem;flex:1}#paradedb-cookie-banner a{color:inherit;text-decoration:underline;text-decoration-color:oklch(86.9% 0.022 252.894);text-underline-offset:2px;transition:color 150ms}#paradedb-cookie-banner a:hover{color:oklch(20.8% 0.042 265.755)}#paradedb-cookie-banner>div{display:flex;width:100%;flex-shrink:0;gap:0.5rem}#paradedb-cookie-banner button{flex:1;cursor:pointer;padding:0.5rem 1rem;min-height:2.5rem;border:1px solid oklch(92.9% 0.013 255.508);border-radius:0;background:transparent;color:inherit;font-size:0.75rem;font-weight:500;line-height:1.333333;white-space:nowrap;transition:color 150ms,\n background-color 150ms,\n border-color 150ms}#paradedb-cookie-banner button:hover{background:oklch(98.4% 0.003 247.858)}#paradedb-cookie-banner button:focus-visible,#paradedb-cookie-banner a:focus-visible{outline:2px solid #6366f1;outline-offset:2px}#paradedb-cookie-banner [data-consent=\"true\"]{background:oklch(96.2% 0.018 272.314);color:oklch(45.7% 0.24 277.023);border-color:oklch(87% 0.065 274.039)}#paradedb-cookie-banner [data-consent=\"true\"]:hover{background:oklch(93% 0.034 272.788)}.dark #paradedb-cookie-banner{color:oklch(70.4% 0.04 256.788);background:oklch(12.9% 0.042 264.695 / 95%);border-color:oklch(27.9% 0.041 260.031)}.dark #paradedb-cookie-banner a{text-decoration-color:oklch(44.6% 0.043 257.281)}.dark #paradedb-cookie-banner a:hover{color:oklch(92.9% 0.013 255.508)}.dark #paradedb-cookie-banner button{color:oklch(86.9% 0.022 252.894);border-color:oklch(27.9% 0.041 260.031)}.dark #paradedb-cookie-banner button:hover{background:oklch(20.8% 0.042 265.755)}.dark #paradedb-cookie-banner [data-consent=\"true\"]{color:oklch(78.5% 0.115 274.713);background:oklch(58.5% 0.233 277.117 / 10%);border-color:oklch(35.9% 0.144 278.697)}.dark #paradedb-cookie-banner [data-consent=\"true\"]:hover{background:oklch(58.5% 0.233 277.117 / 20%)}#paradedb-cookie-banner[hidden]{display:none}@media (min-width: 640px){#paradedb-cookie-banner{flex-direction:row;align-items:center;gap:1.5rem;padding-inline:max(3rem, calc((100vw - 1344px) / 2));font-size:13px}#paradedb-cookie-banner>div{width:auto}#paradedb-cookie-banner button{flex:none}}.paradedb-cookie-footer-row{display:flex;flex-wrap:wrap;align-items:center;gap:0.5rem 1rem}#paradedb-cookie-preferences{color:#9ca3af;background:none;border:0;padding:0;font:inherit;font-size:0.875rem;cursor:pointer}#paradedb-cookie-preferences:hover{color:#4b5563}.dark #paradedb-cookie-preferences{color:#6b7280}.dark #paradedb-cookie-preferences:hover{color:#d1d5db}#paradedb-cookie-preferences:focus-visible{outline:2px solid #6366f1;outline-offset:2px}#paradedb-cookie-preferences[hidden]{display:none}"}],"page":{"pagePath":"project/changelog/0.27.0","slug":"/project/changelog/0.27.0","pageMetadata":{"title":"0.27.0","description":"ParadeDB release notes for 0.27.0","href":"/project/changelog/0.27.0"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"ParadeDB release notes for 0.27.0\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,ul:`ul`,..._provideComponents(),...props.components},{Heading}=_components;if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`See GitHub release: `,_jsx(_components.a,{href:`https://github.com/paradedb/paradedb/releases/tag/v0.27.0`,children:`v0.27.0`})]}),`\n`,_jsx(Heading,{level:`2`,id:`breaking-changes`,children:`Breaking Changes 🚨`}),`\n`,_jsx(Heading,{level:`3`,id:`physical-replication-and-failover-on-paradedb-community`,children:`Physical replication and failover on ParadeDB Community`}),`\n`,_jsxs(_components.p,{children:[`High availability and read replicas have always been ParadeDB Enterprise features, but previously spinning up a physical standby on ParadeDB Community stopped WAL replay entirely when a ParadeDB index was created (#6007). Physical replication is now allowed to continue: non-ParadeDB queries work normally, queries that use a ParadeDB index on a read replica return an error, and if a standby fails over to become a primary (or a server is restored from a base backup taken on a standby) its replicated ParadeDB indexes emit an error and require `,_jsx(_components.code,{children:`REINDEX INDEX`}),`. Backups taken from the primary are unaffected.`]}),`\n`,_jsxs(_components.p,{children:[`Upgrade standbys before the primary: the primary now writes a ParadeDB WAL record during `,_jsx(_components.code,{children:`CREATE INDEX`}),`, `,_jsx(_components.code,{children:`VACUUM`}),`, and `,_jsx(_components.code,{children:`ANALYZE`}),` on indexed tables, and a standby running an earlier release shuts down when replaying that record.`]}),`\n`,_jsx(Heading,{level:`3`,id:`other-changes`,children:`Other Changes`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Adding a vector to an L2 (`,_jsx(_components.code,{children:`vector_l2_ops`}),`) or inner-product (`,_jsx(_components.code,{children:`vector_ip_ops`}),`) field of a ParadeDB index now fails when the vector’s magnitude (its length from the origin) is above about 6.5e18, and searching such a field with a query vector above that magnitude fails too. Vectors that large overflowed the index’s single-precision arithmetic. Cosine fields accept any finite vector. Vectors already in an index are not re-checked, but `,_jsx(_components.code,{children:`REINDEX`}),` of an index holding one fails.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Direct indexing of `,_jsx(_components.code,{children:`ltree`}),` columns in ParadeDB indexes (`,_jsx(_components.code,{children:`USING paradedb (..., path)`}),`) is now deprecated with a create-time warning and will be removed in a future release. Users should create a standard PostgreSQL GiST index on the `,_jsx(_components.code,{children:`ltree`}),` column alongside the ParadeDB index (`,_jsx(_components.code,{children:`USING gist (path)`}),`), which is automatically intersected with ParadeDB searches via bitmap intersection while supporting the full set of `,_jsx(_components.code,{children:`ltree`}),` operators (`,_jsx(_components.code,{children:`\u003c@`}),`, `,_jsx(_components.code,{children:`@>`}),`, `,_jsx(_components.code,{children:`~`}),`, `,_jsx(_components.code,{children:`?`}),`, `,_jsx(_components.code,{children:`@`}),`).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Whole-row searches no longer implicitly target the index’s key field. A bare query such as `,_jsx(_components.code,{children:`t @@@ 'shoes'`}),`\nnow searches across indexed fields. Field-specific builders such as `,_jsx(_components.code,{children:`t @@@ pdb.term('shoes')`}),` now raise an\nerror; use an indexed column instead, for example `,_jsx(_components.code,{children:`t.description @@@ pdb.term('shoes')`}),` or\n`,_jsx(_components.code,{children:`t.description === 'shoes'`}),`. Whole-row `,_jsx(_components.code,{children:`pdb.all()`}),`, `,_jsx(_components.code,{children:`pdb.empty()`}),`, and `,_jsx(_components.code,{children:`pdb.parse()`}),` queries remain supported,\nincluding score adjustments.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Replaced the `,_jsx(_components.code,{children:`vector_fields`}),` JSON index option with `,_jsx(_components.code,{children:`quantization`}),`, which applies to every vector field. It defaults to `,_jsx(_components.code,{children:`'[1,1]'`}),`. Use `,_jsx(_components.code,{children:`quantization = 0`}),` to disable quantization or an array such as `,_jsx(_components.code,{children:`'[1,4]'`}),` to choose layer widths. Recreate indexes that explicitly store `,_jsx(_components.code,{children:`vector_fields`}),` using the new option.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`paradedb.mpp_queue_size`}),` now specifies the per-query DSM byte budget across all SPSC rings in an MPP mesh (default `,_jsx(_components.code,{children:`8MB`}),`, accepting standard PostgreSQL byte units such as `,_jsx(_components.code,{children:`'8MB'`}),` or `,_jsx(_components.code,{children:`'64MB'`}),`) rather than a message count. The `,_jsx(_components.code,{children:`paradedb.mpp_request_timeout`}),` GUC has been removed now that MPP stages stream over event-driven gRPC channels in shared memory.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Removed per-cluster radius pruning and its build, storage, and query costs from IVF vector indexes. Existing IVF indexes require `,_jsx(_components.code,{children:`REINDEX`}),`. `,_jsx(_components.code,{children:`paradedb.vector_clusters`}),` now returns only `,_jsx(_components.code,{children:`segno`}),` and `,_jsx(_components.code,{children:`cluster_sizes`}),`; radius-related EXPLAIN counters have also been removed.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Quantized IVF vector segments store their full-precision rows in document order in an entry of their own, so each cluster block carries document IDs and quantized columns only. Exact scoring reads one row per admitted document from that entry. The `,_jsx(_components.code,{children:`.vec`}),` format moves to version 6; existing vector indexes require `,_jsx(_components.code,{children:`REINDEX`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Renamed the IVF index option `,_jsx(_components.code,{children:`max_leaf_size`}),` to `,_jsx(_components.code,{children:`target_leaf_size`}),`. The value is the target number of indexed vectors per clustering leaf. Training scales it by `,_jsx(_components.code,{children:`training_sample_ratio`}),`; it does not cap the number of indexed vectors assigned to a cluster. Indexes that explicitly store `,_jsx(_components.code,{children:`max_leaf_size`}),` must be updated with `,_jsx(_components.code,{children:`ALTER INDEX ... SET (target_leaf_size = ...)`}),` or recreated.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Term sets in a query (`,_jsx(_components.code,{children:`pdb.term_set`}),`, `,_jsx(_components.code,{children:`===`}),` with an array, or `,_jsx(_components.code,{children:`IN (...)`}),` / `,_jsx(_components.code,{children:`= ANY(...)`}),` on an indexed field) are now capped by the new `,_jsx(_components.code,{children:`paradedb.max_term_set_size`}),` setting, which defaults to `,_jsx(_components.code,{children:`262144`}),` terms. Queries over the limit raise an error, and queries over half the limit emit a warning. Very large term sets are better written as a join; if that is not possible, raise `,_jsx(_components.code,{children:`paradedb.max_term_set_size`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Prebuilt `,_jsx(_components.code,{children:`pg_search`}),` binary packages now require PostgreSQL `,_jsx(_components.code,{children:`15.20`}),`, `,_jsx(_components.code,{children:`16.16`}),`, `,_jsx(_components.code,{children:`17.12`}),`, or `,_jsx(_components.code,{children:`18.7`}),` (or newer within each major series) because `,_jsx(_components.code,{children:`CVE-2026-6460`}),` moved `,_jsx(_components.code,{children:`DatumGetHeapTupleHeader`}),` out of line into the server binary. Upgrade PostgreSQL to at least those point releases before installing or upgrading prebuilt `,_jsx(_components.code,{children:`pg_search`}),` packages; building from source continues to support earlier point releases.`]}),`\n`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`new-features`,children:`New Features ✨`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Set `,_jsx(_components.code,{children:`training_sample_ratio = 0`}),` to automatically size the vector training sample based on available memory. The default remains `,_jsx(_components.code,{children:`0.32`}),` (32%).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Search predicates combined with an OR of indexable conditions now intersect a `,_jsx(_components.code,{children:`BitmapOr`}),` of those conditions’ indexes, rejecting non matching rows without a heap fetch.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`paradedb.vector_info`}),` reports each IVF segment’s router in `,_jsx(_components.code,{children:`vector_router`}),` and the number of centroids at each router level, bottom to top, in `,_jsx(_components.code,{children:`vector_router_levels`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Vector indexes default to `,_jsx(_components.code,{children:`replication = 2`}),`: each vector of a quantized IVF field is also assigned to a second cluster chosen to cover queries its first cluster misses. Replication roughly doubles the quantized rows scanned per opened cluster and the index build time, and adds about one quantized row per vector to the index; full-precision rows are not duplicated. It applies to newly clustered segments. Set `,_jsx(_components.code,{children:`replication = 1`}),` to disable the second assignment.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Match, phrase and query parser queries expand with synonym rules that you keep in a table. Give the rules to `,_jsx(_components.code,{children:`|||`}),`, `,_jsx(_components.code,{children:`\u0026\u0026\u0026`}),`, `,_jsx(_components.code,{children:`###`}),` or `,_jsx(_components.code,{children:`@@@`}),` with a subquery, as in `,_jsx(_components.code,{children:`description ||| (SELECT pdb.expand('sofa', rule) FROM shop_synonyms)`}),`. A change to the rules applies on the next query with no reindex. See `,_jsx(_components.a,{href:`/reference/tokenizers/synonyms`,children:`Synonyms`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`pdb.explain_score(\u003ccolumn>)`}),` explains the BM25 score of a row as `,_jsx(_components.code,{children:`jsonb`}),`, with the idf, the frequency and the field length of each term that the row matches. A synonym group explains as one term and lists the words of the group that the row holds. See `,_jsx(_components.a,{href:`/reference/full-text/score#score-explanation`,children:`Score Explanation`}),`.`]}),`\n`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`performance-improvements`,children:`Performance Improvements 🚀`}),`\n`,_jsx(Heading,{level:`3`,id:`global-vector-routing`,children:`Global vector routing`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`paradedb.vector_cluster_max_probe`}),` now sets an absolute work budget in average-cluster units, accepting whole numbers from `,_jsx(_components.code,{children:`1`}),` through `,_jsx(_components.code,{children:`100000`}),` with a default of `,_jsx(_components.code,{children:`100`}),`. Opening clusters and scoring rows consume the same cost-based budget; selective filters can visit more clusters. Update existing values to the desired absolute budget.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`other-changes-2`,children:`Other Changes`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Sign-quantized vector scans run faster on CPUs with AVX-512 VPOPCNTDQ (Intel Ice Lake-SP and later, AMD Zen 4 and later). Scores and the index format are unchanged.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Set the default IVF `,_jsx(_components.code,{children:`target_leaf_size`}),` to `,_jsx(_components.code,{children:`400`}),` indexed vectors per leaf. Existing clusters and explicit `,_jsx(_components.code,{children:`target_leaf_size`}),` settings are unchanged.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Vector searches reuse prepared query data across centroid routing and exact reranking and read centroids in batches, reducing repeated computation and storage reads.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Stacked IVF list selection now scales with the number of clusters a query asks to probe, so every stacked IVF index can see different recall and latency. The probe stops only on the work budget (`,_jsx(_components.code,{children:`paradedb.vector_cluster_max_probe`}),`) or when the ranking runs out. L2 and cosine indexes at 128 dimensions or fewer also no longer stop early through geometry-based adaptive partition scanning. `,_jsx(_components.code,{children:`paradedb.vector_router_recall_target`}),` and `,_jsx(_components.code,{children:`paradedb.vector_recall_target`}),` remain accepted and have no effect.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Vector routing stops after five quiet clusters instead of a short row budget, so a single large cluster no longer ends the probe early.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Vector `,_jsx(_components.code,{children:`ORDER BY`}),` searches share a top-k pruning threshold across segments and parallel workers on the same query, so later segments can cut work using scores already found elsewhere.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Vector index builds run faster. Each vector’s second (replica) cluster comes from the nearest-centroid pass and the centroids’ Gram matrix instead of a second pass over every centroid, and a quantized segment encodes its clusters in parallel. On x86 CPUs with AVX2 and FMA, and with SSE4.1, quantized scoring and query preparation use those instructions instead of math-library calls. Quantized encoding and scoring are unchanged bit for bit; replica clusters can differ where two candidates tie to floating-point rounding.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Faster vector index builds and query preparation with quantization (the default), using branch-free encoding everywhere and SIMD kernels on x86. Encoded rows and search results are unchanged.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Aggregate Scan now answers `,_jsx(_components.code,{children:`COUNT(col) ... GROUP BY col`}),` for text, boolean and JSON columns from each group’s document count instead of computing a separate metric, which speeds up grouped counts such as `,_jsx(_components.code,{children:`SELECT name, COUNT(name) ... GROUP BY name`}),` (#6707).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Added adaptive stopping for vector cluster probing. `,_jsx(_components.code,{children:`paradedb.vector_cluster_max_probe`}),` continues to control the router request and probe-work ceiling; `,_jsx(_components.code,{children:`paradedb.vector_adaptive_probing`}),` allows the scan to stop sooner when competitive-candidate admission decays.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Vector indexes quantize the IVF router by default: new segments route each query through one-bit codes of the centroids and rerank the shortlisted centroids exactly. `,_jsx(_components.code,{children:`vector_router_quantization = false`}),` keeps full-precision routing; segments keep the router they were clustered with until the index is rebuilt.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Vector searches do less work per scanned row on replicated IVF indexes (the default `,_jsx(_components.code,{children:`replication = 2`}),`): clusters whose rows an earlier cluster already holds are scored through the batch kernels and decoders, read planning skips pricing sparse reads that cannot beat a whole-cluster read, and each cluster’s storage block is looked up fewer times. Results and the index format are unchanged.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fuzzy matches (`,_jsx(_components.code,{children:`||| 'x'::pdb.fuzzy(1)`}),`, `,_jsx(_components.code,{children:`pdb.match('x', distance => 1)`}),`) plan as fast as `,_jsx(_components.code,{children:`pdb.fuzzy_term`}),`. The planner uses its selectivity heuristic for them instead of building the fuzzy automaton, so their row estimate becomes a fixed fraction of the table. `,_jsx(_components.code,{children:`paradedb.enable_heuristic_selectivity = off`}),` gives the estimate from the index.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Vector `,_jsx(_components.code,{children:`ORDER BY`}),` searches cost less per query. The plan carries the query vector once, in a compact form, instead of twice as a list of numbers; per-segment scan statistics are built only when `,_jsx(_components.code,{children:`EXPLAIN ANALYZE`}),` or `,_jsx(_components.code,{children:`paradedb.vector_stats`}),` shows them; and the exact phase scores the most promising candidates first, so fewer of the rest are read and scored. Because that order changes which candidates near the cutoff are dropped, a top-k result can differ in rare cases. Planning a query that matches every row, such as `,_jsx(_components.code,{children:`@@@ paradedb.all()`}),`, on an index without a `,_jsx(_components.code,{children:`WHERE`}),` predicate estimates its selectivity and segment count without opening the index, so the planner’s row estimate for it is the table’s row count. Index page reads first try the shared buffer that last held the page and fall back to the usual buffer lookup. The index format is unchanged.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Range filters (`,_jsx(_components.code,{children:`\u003c`}),`, `,_jsx(_components.code,{children:`\u003c=`}),`, `,_jsx(_components.code,{children:`>`}),`, `,_jsx(_components.code,{children:`>=`}),`, `,_jsx(_components.code,{children:`BETWEEN`}),`, and `,_jsx(_components.code,{children:`pdb.range`}),`) now produce more accurate row estimates on skewed columns, and joins with query parameters (`,_jsx(_components.code,{children:`$1`}),`) or subqueries refine their estimates once parameter values are bound. Selective `,_jsx(_components.code,{children:`ORDER BY ... LIMIT`}),` joins (ordered by search score, vector distance, or an indexed column) use these estimates to push matching join keys directly into the search or vector index instead of scanning past non-matching rows.`]}),`\n`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`stability-improvements`,children:`Stability Improvements 💪`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed `,_jsx(_components.code,{children:`pdb.parse()`}),` queries on `,_jsx(_components.code,{children:`NUMERIC`}),` fields that returned wrong rows, no rows, or parse errors. Literals, ranges, and sets use exact comparisons, and invalid input follows strict or lenient parsing rules (#6105).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Range-partitioned parallel joins on `,_jsx(_components.code,{children:`NUMERIC`}),` columns no longer skew every row into the first partition, and no longer fail for `,_jsx(_components.code,{children:`NUMERIC`}),` columns without a precision.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`NUMERIC`}),` columns declared with a scale outside -18 to 18, such as `,_jsx(_components.code,{children:`numeric(3,20)`}),`, can now be indexed. They used to fail with an error ending in `,_jsx(_components.code,{children:`exceeds maximum 18 for Decimal64NoScale`}),`, either at `,_jsx(_components.code,{children:`CREATE INDEX`}),` or on the first search after a row was inserted. An index created on an earlier version keeps its previous layout for such a column and still fails this way, so run `,_jsx(_components.code,{children:`REINDEX`}),` on any index that hit this error.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A search read now takes a predicate lock under `,_jsx(_components.code,{children:`SERIALIZABLE`}),`. Without it, two transactions could each count the rows matching a search, then each insert a matching row, and both commit, while Postgres’ own plans for the same read abort one of them (#6390). The lock covers the whole table, so a write from another `,_jsx(_components.code,{children:`SERIALIZABLE`}),` transaction creates a dependency with the read even when it touches a row the search did not match.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A `,_jsx(_components.code,{children:`LIMIT`}),` query over a bitmap intersection no longer fails with “bitmap intersection stream … claimed twice” when it has to search again, for example after deleted rows hid its first batch, or when a window aggregate runs alongside it (#6403).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed a search operator in the `,_jsx(_components.code,{children:`SELECT`}),` list, such as `,_jsx(_components.code,{children:`title ||| 'alpha'`}),`, being charged `,_jsx(_components.code,{children:`paradedb.per_tuple_cost`}),`. The inflated cost pushed small queries past the JIT thresholds and made them much slower (#6406).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A heap filter that calls an allocating function, such as `,_jsx(_components.code,{children:`tags @> jsonb_build_array('x')`}),`, no longer grows the backend’s memory with every row it rejects (#6739).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed JoinScan returning `,_jsx(_components.code,{children:`NULL`}),` for selected system columns (`,_jsx(_components.code,{children:`ctid`}),`, `,_jsx(_components.code,{children:`tableoid`}),`, `,_jsx(_components.code,{children:`xmin`}),`, `,_jsx(_components.code,{children:`cmin`}),`, `,_jsx(_components.code,{children:`xmax`}),`, and `,_jsx(_components.code,{children:`cmax`}),`). Matched rows now return the system attributes of the fetched heap tuple; unmatched outer-join rows still return `,_jsx(_components.code,{children:`NULL`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Construct operator function expressions through PostgreSQL’s node constructor so additional server-defined fields do not cause missing-field initializer errors.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Filters that compare a `,_jsx(_components.code,{children:`NUMERIC(p, s)`}),` column with `,_jsx(_components.code,{children:`p`}),` of 18 or less to a literal carrying more decimal places than `,_jsx(_components.code,{children:`s`}),`, such as `,_jsx(_components.code,{children:`price = 10.005`}),` on a `,_jsx(_components.code,{children:`numeric(10,2)`}),` column, now return the same rows as PostgreSQL. The pushed-down query used to round the literal to the column’s scale first, so equality, `,_jsx(_components.code,{children:`IN`}),` and range filters could match the wrong rows. Comparing the column with a very large literal, such as `,_jsx(_components.code,{children:`price > 1e17`}),`, no longer raises an error.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`NOT (field @@@ \u003cexpr>)`}),` no longer returns every row when `,_jsx(_components.code,{children:`\u003cexpr>`}),` evaluates to NULL.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed `,_jsx(_components.code,{children:`paradedb.planner_warnings`}),` so runtime scan, spill, and visibility-map diagnostics honor `,_jsx(_components.code,{children:`off`}),` and `,_jsx(_components.code,{children:`error`}),`, `,_jsx(_components.code,{children:`EXPLAIN ANALYZE`}),` enforces error mode, and changing the setting invalidates cached plans.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed incorrect `,_jsx(_components.code,{children:`DISTINCT`}),` and `,_jsx(_components.code,{children:`GROUP BY`}),` results for array columns and expressions over them, including slices, subscripts, and domain casts. These queries now use PostgreSQL aggregation to preserve empty arrays, NULL elements, dimensions, and lower bounds.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed `,_jsx(_components.code,{children:`COUNT(array_column)`}),` and `,_jsx(_components.code,{children:`COUNT(array_column) OVER ()`}),` counting array elements instead of non-NULL rows, including empty arrays and arrays containing only NULLs.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Filters on `,_jsx(_components.code,{children:`ctid`}),` or `,_jsx(_components.code,{children:`tableoid`}),` that ParadeDB evaluates against the heap, such as `,_jsx(_components.code,{children:`b.ctid > '(0,2)'`}),` on a Join Scan source, now return the same rows as PostgreSQL. The filter used to compare an invalid `,_jsx(_components.code,{children:`ctid`}),` and a zero `,_jsx(_components.code,{children:`tableoid`}),`, so it matched every row or none.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Integer `,_jsx(_components.code,{children:`+`}),`, `,_jsx(_components.code,{children:`-`}),` and `,_jsx(_components.code,{children:`*`}),` in expressions evaluated by the Join Scan now raise an out-of-range error on overflow instead of silently wrapping.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Float division by zero in expressions evaluated by the Join Scan now raises `,_jsx(_components.code,{children:`division by zero`}),` instead of returning `,_jsx(_components.code,{children:`Infinity`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`sum()`}),` over a `,_jsx(_components.code,{children:`bigint`}),` column in an aggregate over a join now returns the exact total instead of silently wrapping on overflow.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`remove_short`}),` and `,_jsx(_components.code,{children:`remove_long`}),` now measure tokens after `,_jsx(_components.code,{children:`trim=true`}),` removes their surrounding whitespace. Reindex existing indexes that combine `,_jsx(_components.code,{children:`trim=true`}),` with either length filter to make previously indexed values consistent with queries and new writes. Existing indexes remain usable without reindexing, but affected values may return different or incomplete results.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`The JSONB `,_jsx(_components.code,{children:`?`}),` operator now matches PostgreSQL in a ParadeDB scan, including string elements of a top-level array, a top-level string scalar, keys with a `,_jsx(_components.code,{children:`null`}),` value, and keys that contain a dot.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`sum()`}),` over a `,_jsx(_components.code,{children:`bigint`}),` column in a single-table aggregate now returns the exact total instead of rounding values past 2^53.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed join filters over `,_jsx(_components.code,{children:`NUMERIC`}),` columns in the aggregate scan and JoinScan, which read the stored scaled values and could return wrong results or fail. For example, comparing `,_jsx(_components.code,{children:`numeric(10,2)`}),` with `,_jsx(_components.code,{children:`numeric(10,3)`}),`, or `,_jsx(_components.code,{children:`floor(a.amt) \u003c> b.amt`}),`, now matches PostgreSQL.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsx(_components.p,{children:`Fixed precision loss in numeric constants used by pushed-down aggregate HAVING and FILTER comparisons.`}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`paradedb.range()`}),` on a JSON numeric path no longer matches fractional values outside an integer bound, such as `,_jsx(_components.code,{children:`[5,5]`}),` matching `,_jsx(_components.code,{children:`5.5`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`ORDER BY ... LIMIT`}),` with `,_jsx(_components.code,{children:`FOR UPDATE SKIP LOCKED`}),` no longer returns fewer rows than the limit when the top-ranked rows are locked by another transaction.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed an `,_jsx(_components.code,{children:`unrecognized node type`}),` error when using `,_jsx(_components.code,{children:`pdb.score()`}),` inside arithmetic or text expressions in join predicates and aggregate filters.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed an internal error in filters comparing a `,_jsx(_components.code,{children:`real`}),` or `,_jsx(_components.code,{children:`double precision`}),` column with `,_jsx(_components.code,{children:`NaN`}),`, `,_jsx(_components.code,{children:`Infinity`}),` or `,_jsx(_components.code,{children:`-Infinity`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Stopwords (`,_jsx(_components.code,{children:`stopwords_language`}),` and `,_jsx(_components.code,{children:`stopwords`}),`) are now removed before stemming and ASCII folding. Previously, a transformed stopword could be indexed, such as Spanish `,_jsx(_components.code,{children:`para`}),` stemmed to `,_jsx(_components.code,{children:`par`}),`. Existing indexes that combine stopwords with stemming or ASCII folding remain usable, but searches can miss matches or return extra matches because older rows were indexed with the previous filter order. Run `,_jsx(_components.code,{children:`REINDEX`}),` on affected indexes to make results consistent across existing rows and new writes.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed IVF `,_jsx(_components.code,{children:`target_leaf_size`}),` so it describes the desired full-dataset leaf size. Training now scales it by `,_jsx(_components.code,{children:`training_sample_ratio`}),` (the default `,_jsx(_components.code,{children:`400`}),` trains at `,_jsx(_components.code,{children:`128`}),`) so final clusters stay near the configured target. Existing indexes are unaffected until they are rebuilt.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Queries that run as an Aggregate Scan or Join Scan no longer crash the backend when `,_jsx(_components.code,{children:`auto_explain`}),` logs their plan without `,_jsx(_components.code,{children:`log_analyze`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`PL/pgSQL variables used as `,_jsx(_components.code,{children:`LIMIT`}),`/`,_jsx(_components.code,{children:`OFFSET`}),`, as `,_jsx(_components.code,{children:`pdb.snippet()`}),` arguments, or as a vector `,_jsx(_components.code,{children:`ORDER BY`}),` operand now keep their values once the statement switches to a generic plan, instead of returning wrong rows or crashing the backend.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Under `,_jsx(_components.code,{children:`SERIALIZABLE`}),`, an aggregate that runs with MPP no longer misses an `,_jsx(_components.code,{children:`INSERT`}),` that commits after the query starts but before it reads the index. Both transactions could commit with write skew (#7428).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A query that negates a fuzzy or regex clause next to another filter, such as `,_jsx(_components.code,{children:`lang === 'ja' AND NOT (title === 'x'::pdb.fuzzy(1))`}),`, gets its row estimate from the index. The planner used to plan it as one row.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Fixed Join Scans restarting from the first row on each cursor fetch, which could cause PL/pgSQL `,_jsx(_components.code,{children:`FOR`}),` loops to run indefinitely. Fixed cursors over DataFusion Aggregate Scans stopping after the first 8192 groups.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Align parallel `,_jsx(_components.code,{children:`JoinScan`}),`, `,_jsx(_components.code,{children:`AggregateScan`}),`, and `,_jsx(_components.code,{children:`BaseScan`}),` execution with PostgreSQL’s `,_jsx(_components.code,{children:`parallel_leader_participation`}),` GUC, per-table `,_jsx(_components.code,{children:`parallel_workers`}),` reloption, and parallel-mode safety rules (`,_jsx(_components.code,{children:`TEMP`}),` tables, `,_jsx(_components.code,{children:`PARALLEL RESTRICTED`}),` expressions, and partial cursor/portal fetches).`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Reject negative `,_jsx(_components.code,{children:`slop`}),` values in `,_jsx(_components.code,{children:`pdb.phrase`}),` and `,_jsx(_components.code,{children:`pdb.regex_phrase`}),` instead of matching terms farther apart than intended.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`pdb.agg()`}),` over a join now reads a column indexed inside a composite type, such as `,_jsx(_components.code,{children:`ROW(category)::item_fields`}),`, instead of failing with `,_jsx(_components.code,{children:`Field 'category' is an expression index, which cannot be read back as a column`}),`.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`Reject negative `,_jsx(_components.code,{children:`max_expansion`}),` values in `,_jsx(_components.code,{children:`pdb.phrase_prefix`}),` instead of converting them to large unsigned limits.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`@@@`}),` no longer fails with an internal error for a `,_jsx(_components.code,{children:`pdb.query`}),` value known only at run time, such as a subquery or a parameter of a generic plan.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A phrase query keeps the positions of its tokens. So `,_jsx(_components.code,{children:`###`}),` finds `,_jsx(_components.code,{children:`sofa of leather`}),` on a field that removes stop words, and it matches a word on a `,_jsx(_components.code,{children:`pdb.edge_ngram`}),` field.`]}),`\n`]}),`\n`,_jsxs(_components.li,{children:[`\n`,_jsxs(_components.p,{children:[`A configuration reload during a Join Scan or Aggregate Scan query that runs with MPP workers no longer fails the query with `,_jsx(_components.code,{children:`parameter ... cannot be set during a parallel operation`}),`.`]}),`\n`]}),`\n`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"0.27.0","description":"ParadeDB release notes for 0.27.0","href":"/project/changelog/0.27.0"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Breaking Changes 🚨","slug":"breaking-changes","depth":2,"children":[{"title":"Physical replication and failover on ParadeDB Community","slug":"physical-replication-and-failover-on-paradedb-community","depth":3,"children":[]},{"title":"Other Changes","slug":"other-changes","depth":3,"children":[]}]},{"title":"New Features ✨","slug":"new-features","depth":2,"children":[]},{"title":"Performance Improvements 🚀","slug":"performance-improvements","depth":2,"children":[{"title":"Global vector routing","slug":"global-vector-routing","depth":3,"children":[]},{"title":"Other Changes","slug":"other-changes-2","depth":3,"children":[]}]},{"title":"Stability Improvements 💪","slug":"stability-improvements","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/paradedb/1aef07ebece82dbc/override.js","/docs/_mintlify/custom/paradedb/7c9e7967ab38976d/analytics.js"],"subdomain":"paradedb","siteName":"ParadeDB","title":"0.27.0 - ParadeDB","navMaps":{"firstHrefInVersion":{"v0.27.0":{"href":"/project/changelog/0.27.0","matchLevel":0}},"firstHrefInLanguage":{}},"lastModified":"2026-11-19T06:42:05.174Z","originalFileLocation":"project/changelog/0.27.0.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"ParadeDB release notes for 0.27.0\">\u003cmeta data-mint-head name=\"keywords\" content=\"paradedb, postgres, search, analytics, bm25, full-text search, vector search, semantic search, hybrid search, faceted search, columnar, olap\">\u003cmeta data-mint-head name=\"application-name\" content=\"ParadeDB\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"0.27.0 - ParadeDB\">\u003cmeta data-mint-head property=\"og:description\" content=\"You should just use Postgres.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ParadeDB\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://www.paradedb.com/docs/project/changelog/0.27.0\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://www.paradedb.com/opengraph-image.png\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"0.27.0 - ParadeDB\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"You should just use Postgres.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://www.paradedb.com/opengraph-image.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/paradedb/xZnm2E-sMpJPUBVi/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"ParadeDB Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#4f46e5\">\u003cmeta data-mint-head name=\"og:locale\" content=\"en_US\">\u003cmeta data-mint-head name=\"charset\" content=\"UTF-8\">\u003cmeta data-mint-head name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\u003cmeta data-mint-head name=\"author\" content=\"ParadeDB\">\u003cmeta data-mint-head name=\"google\" content=\"notranslate\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003cmeta data-mint-head name=\"theme-color\" content=\"#000000\">\u003cmeta data-mint-head name=\"color-scheme\" content=\"light dark\">\u003cmeta data-mint-head name=\"referrer\" content=\"origin\">\u003cmeta data-mint-head name=\"rating\" content=\"general\">\u003cmeta data-mint-head name=\"revisit-after\" content=\"7 days\">\u003cmeta data-mint-head name=\"language\" content=\"en\">\u003cmeta data-mint-head name=\"copyright\" content=\"ParadeDB, Inc. 2026\">\u003cmeta data-mint-head name=\"reply-to\" content=\"support@paradedb.com\">\u003cmeta data-mint-head name=\"distribution\" content=\"global\">\u003cmeta data-mint-head name=\"coverage\" content=\"Worldwide\">\u003cmeta data-mint-head name=\"category\" content=\"Technology\">\u003cmeta data-mint-head name=\"target\" content=\"all\">\u003cmeta data-mint-head name=\"HandheldFriendly\" content=\"True\">\u003cmeta data-mint-head name=\"MobileOptimized\" content=\"320\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-capable\" content=\"yes\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-status-bar-style\" content=\"black\">\u003cmeta data-mint-head name=\"og:image:alt\" content=\"ParadeDB: Just use Postgres\">\u003cmeta data-mint-head name=\"twitter:creator\" content=\"@paradedb\">\u003cmeta data-mint-head name=\"twitter:image:alt\" content=\"ParadeDB: Just use Postgres\">\u003clink data-mint-head rel=\"canonical\" href=\"https://www.paradedb.com/docs/project/changelog/0.27.0\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/project/changelog/0.27.0.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://www.paradedb.com/#organization\",\"name\":\"ParadeDB\",\"url\":\"https://www.paradedb.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/paradedb/X75hU2Xqk72Fhmya/logo/light.svg?fit=max\u0026auto=format\u0026n=X75hU2Xqk72Fhmya\u0026q=85\u0026s=ac5ce043daf4c85d48b56bcd7f69c14f\"}},{\"@type\":\"WebSite\",\"@id\":\"https://www.paradedb.com/docs#website\",\"name\":\"ParadeDB\",\"url\":\"https://www.paradedb.com/docs\",\"publisher\":{\"@id\":\"https://www.paradedb.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://www.paradedb.com/docs/project/changelog/0.27.0#webpage\",\"url\":\"https://www.paradedb.com/docs/project/changelog/0.27.0\",\"name\":\"0.27.0\",\"description\":\"ParadeDB release notes for 0.27.0\",\"dateModified\":\"2026-11-19T06:42:05.174Z\",\"isPartOf\":{\"@id\":\"https://www.paradedb.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://www.paradedb.com/docs/project/changelog/0.27.0#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://www.paradedb.com/docs/project/changelog/0.27.0#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Changelog\",\"item\":\"https://www.paradedb.com/docs/project/changelog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"0.27.0\",\"item\":\"https://www.paradedb.com/docs/project/changelog/0.27.0\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://www.paradedb.com/docs/project/changelog/0.27.0#article\",\"headline\":\"0.27.0\",\"name\":\"0.27.0\",\"description\":\"ParadeDB release notes for 0.27.0\",\"url\":\"https://www.paradedb.com/docs/project/changelog/0.27.0\",\"mainEntityOfPage\":{\"@id\":\"https://www.paradedb.com/docs/project/changelog/0.27.0#webpage\"},\"image\":\"https://www.paradedb.com/opengraph-image.png\",\"dateModified\":\"2026-11-19T06:42:05.174Z\",\"publisher\":{\"@id\":\"https://www.paradedb.com/#organization\"},\"isPartOf\":{\"@id\":\"https://www.paradedb.com/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"ParadeDB\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"ParadeDB\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/project/changelog/0.27.0.md","siteName":"ParadeDB","nav":{"global":null,"versions":[{"version":"v0.27.0","tabs":[{"tab":"Start","icon":"rocket","pages":[{"title":"Start","href":"/start/introduction"}]},{"tab":"Reference","icon":"book-open","pages":[{"title":"Reference","href":"/reference/overview"}]},{"tab":"Concepts","icon":"lightbulb","pages":[{"title":"Concepts","href":"/concepts/architecture"}]},{"tab":"Operate","icon":"server","pages":[{"title":"Operate","href":"/operate/deploy/enterprise"}]},{"tab":"Project","icon":"flag","pages":[{"title":"Roadmap","href":"/project/roadmap"},{"group":"Changelog","pages":[{"title":"Changelog","sidebarTitle":"Overview","description":"Release notes for ParadeDB","href":"/project/changelog"},{"group":"v0.27","expanded":false,"pages":[{"title":"0.27.0","href":"/project/changelog/0.27.0"}]},{"group":"Older","expanded":false,"pages":[{"group":"v0.26","expanded":false,"pages":[{"title":"0.26.8","description":"ParadeDB release notes for 0.26.8","href":"/project/changelog/0.26.8"},{"title":"0.26.7","href":"/project/changelog/0.26.7"},{"title":"0.26.6","href":"/project/changelog/0.26.6"},{"title":"0.26.5","href":"/project/changelog/0.26.5"},{"title":"0.26.4","href":"/project/changelog/0.26.4"},{"title":"0.26.3","href":"/project/changelog/0.26.3"},{"title":"0.26.2","href":"/project/changelog/0.26.2"},{"title":"0.26.1","href":"/project/changelog/0.26.1"},{"title":"0.26.0","href":"/project/changelog/0.26.0"}]},{"group":"v0.25","expanded":false,"pages":[{"title":"0.25.11","href":"/project/changelog/0.25.11"},{"title":"0.25.10","href":"/project/changelog/0.25.10"},{"title":"0.25.9","href":"/project/changelog/0.25.9"},{"title":"0.25.8","href":"/project/changelog/0.25.8"},{"title":"0.25.7","href":"/project/changelog/0.25.7"},{"title":"0.25.6","href":"/project/changelog/0.25.6"},{"title":"0.25.5","href":"/project/changelog/0.25.5"},{"title":"0.25.4","href":"/project/changelog/0.25.4"},{"title":"0.25.3","href":"/project/changelog/0.25.3"},{"title":"0.25.2","href":"/project/changelog/0.25.2"},{"title":"0.25.1","href":"/project/changelog/0.25.1"},{"title":"0.25.0","href":"/project/changelog/0.25.0"}]},{"group":"v0.24","expanded":false,"pages":[{"title":"0.24.3","href":"/project/changelog/0.24.3"},{"title":"0.24.2","href":"/project/changelog/0.24.2"},{"title":"0.24.1","href":"/project/changelog/0.24.1"},{"title":"0.24.0","href":"/project/changelog/0.24.0"}]},{"group":"v0.23","expanded":false,"pages":[{"title":"0.23.5","href":"/project/changelog/0.23.5"},{"title":"0.23.4","href":"/project/changelog/0.23.4"},{"title":"0.23.3","href":"/project/changelog/0.23.3"},{"title":"0.23.2","href":"/project/changelog/0.23.2"},{"title":"0.23.1","href":"/project/changelog/0.23.1"},{"title":"0.23.0","href":"/project/changelog/0.23.0"}]},{"group":"v0.22","expanded":false,"pages":[{"title":"0.22.6","href":"/project/changelog/0.22.6"},{"title":"0.22.5","href":"/project/changelog/0.22.5"},{"title":"0.22.4","href":"/project/changelog/0.22.4"},{"title":"0.22.3","href":"/project/changelog/0.22.3"},{"title":"0.22.2","href":"/project/changelog/0.22.2"},{"title":"0.22.1","href":"/project/changelog/0.22.1"},{"title":"0.22.0","href":"/project/changelog/0.22.0"}]},{"group":"v0.21","expanded":false,"pages":[{"title":"0.21.16","href":"/project/changelog/0.21.16"},{"title":"0.21.15","href":"/project/changelog/0.21.15"},{"title":"0.21.14","href":"/project/changelog/0.21.14"},{"title":"0.21.13","href":"/project/changelog/0.21.13"},{"title":"0.21.12","href":"/project/changelog/0.21.12"},{"title":"0.21.11","href":"/project/changelog/0.21.11"},{"title":"0.21.10","href":"/project/changelog/0.21.10"},{"title":"0.21.9","href":"/project/changelog/0.21.9"},{"title":"0.21.8","href":"/project/changelog/0.21.8"},{"title":"0.21.7","href":"/project/changelog/0.21.7"},{"title":"0.21.6","href":"/project/changelog/0.21.6"},{"title":"0.21.5","href":"/project/changelog/0.21.5"},{"title":"0.21.4","href":"/project/changelog/0.21.4"},{"title":"0.21.3","href":"/project/changelog/0.21.3"},{"title":"0.21.2","href":"/project/changelog/0.21.2"},{"title":"0.21.1","href":"/project/changelog/0.21.1"},{"title":"0.21.0","href":"/project/changelog/0.21.0"}]},{"group":"v0.20","expanded":false,"pages":[{"title":"0.20.11","href":"/project/changelog/0.20.11"},{"title":"0.20.10","href":"/project/changelog/0.20.10"},{"title":"0.20.9","href":"/project/changelog/0.20.9"},{"title":"0.20.8","href":"/project/changelog/0.20.8"},{"title":"0.20.7","href":"/project/changelog/0.20.7"},{"title":"0.20.6","href":"/project/changelog/0.20.6"},{"title":"0.20.5","href":"/project/changelog/0.20.5"},{"title":"0.20.4","href":"/project/changelog/0.20.4"},{"title":"0.20.3","href":"/project/changelog/0.20.3"},{"title":"0.20.2","href":"/project/changelog/0.20.2"},{"title":"0.20.1","href":"/project/changelog/0.20.1"},{"title":"0.20.0","href":"/project/changelog/0.20.0"}]},{"group":"v0.19","expanded":false,"pages":[{"title":"0.19.11","href":"/project/changelog/0.19.11"},{"title":"0.19.10","href":"/project/changelog/0.19.10"},{"title":"0.19.9","href":"/project/changelog/0.19.9"},{"title":"0.19.8","href":"/project/changelog/0.19.8"},{"title":"0.19.7","href":"/project/changelog/0.19.7"},{"title":"0.19.6","href":"/project/changelog/0.19.6"},{"title":"0.19.5","href":"/project/changelog/0.19.5"},{"title":"0.19.4","href":"/project/changelog/0.19.4"},{"title":"0.19.3","href":"/project/changelog/0.19.3"},{"title":"0.19.2","href":"/project/changelog/0.19.2"},{"title":"0.19.1","href":"/project/changelog/0.19.1"},{"title":"0.19.0","href":"/project/changelog/0.19.0"}]},{"group":"v0.18","expanded":false,"pages":[{"title":"0.18.15","href":"/project/changelog/0.18.15"},{"title":"0.18.14","href":"/project/changelog/0.18.14"},{"title":"0.18.13","href":"/project/changelog/0.18.13"},{"title":"0.18.12","href":"/project/changelog/0.18.12"},{"title":"0.18.11","href":"/project/changelog/0.18.11"},{"title":"0.18.10","href":"/project/changelog/0.18.10"},{"title":"0.18.9","href":"/project/changelog/0.18.9"},{"title":"0.18.8","href":"/project/changelog/0.18.8"},{"title":"0.18.7","href":"/project/changelog/0.18.7"},{"title":"0.18.6","href":"/project/changelog/0.18.6"},{"title":"0.18.5","href":"/project/changelog/0.18.5"},{"title":"0.18.4","href":"/project/changelog/0.18.4"},{"title":"0.18.3","href":"/project/changelog/0.18.3"},{"title":"0.18.2","href":"/project/changelog/0.18.2"},{"title":"0.18.1","href":"/project/changelog/0.18.1"},{"title":"0.18.0","href":"/project/changelog/0.18.0"}]},{"group":"v0.17","expanded":false,"pages":[{"title":"0.17.12","href":"/project/changelog/0.17.12"},{"title":"0.17.10","href":"/project/changelog/0.17.10"},{"title":"0.17.9","href":"/project/changelog/0.17.9"},{"title":"0.17.8","href":"/project/changelog/0.17.8"},{"title":"0.17.7","href":"/project/changelog/0.17.7"},{"title":"0.17.6","href":"/project/changelog/0.17.6"},{"title":"0.17.5","href":"/project/changelog/0.17.5"},{"title":"0.17.4","href":"/project/changelog/0.17.4"},{"title":"0.17.3","href":"/project/changelog/0.17.3"},{"title":"0.17.2","href":"/project/changelog/0.17.2"},{"title":"0.17.1","href":"/project/changelog/0.17.1"},{"title":"0.17.0","href":"/project/changelog/0.17.0"}]},{"group":"v0.16","expanded":false,"pages":[{"title":"0.16.5","href":"/project/changelog/0.16.5"},{"title":"0.16.4","href":"/project/changelog/0.16.4"},{"title":"0.16.3","href":"/project/changelog/0.16.3"},{"title":"0.16.2","href":"/project/changelog/0.16.2"},{"title":"0.16.1","href":"/project/changelog/0.16.1"},{"title":"0.16.0","href":"/project/changelog/0.16.0"}]},{"group":"v0.15","expanded":false,"pages":[{"title":"0.15.26","href":"/project/changelog/0.15.26"},{"title":"0.15.25","href":"/project/changelog/0.15.25"},{"title":"0.15.24","href":"/project/changelog/0.15.24"},{"title":"0.15.23","href":"/project/changelog/0.15.23"},{"title":"0.15.22","href":"/project/changelog/0.15.22"},{"title":"0.15.21","href":"/project/changelog/0.15.21"},{"title":"0.15.20","href":"/project/changelog/0.15.20"},{"title":"0.15.19","href":"/project/changelog/0.15.19"},{"title":"0.15.18","href":"/project/changelog/0.15.18"},{"title":"0.15.17","href":"/project/changelog/0.15.17"},{"title":"0.15.16","href":"/project/changelog/0.15.16"},{"title":"0.15.15","href":"/project/changelog/0.15.15"},{"title":"0.15.14","href":"/project/changelog/0.15.14"},{"title":"0.15.13","href":"/project/changelog/0.15.13"},{"title":"0.15.12","href":"/project/changelog/0.15.12"},{"title":"0.15.11","href":"/project/changelog/0.15.11"},{"title":"0.15.10","href":"/project/changelog/0.15.10"},{"title":"0.15.9","href":"/project/changelog/0.15.9"},{"title":"0.15.8","href":"/project/changelog/0.15.8"},{"title":"0.15.7","href":"/project/changelog/0.15.7"},{"title":"0.15.6","href":"/project/changelog/0.15.6"},{"title":"0.15.5","href":"/project/changelog/0.15.5"},{"title":"0.15.4","href":"/project/changelog/0.15.4"},{"title":"0.15.3","href":"/project/changelog/0.15.3"},{"title":"0.15.2","href":"/project/changelog/0.15.2"},{"title":"0.15.1","href":"/project/changelog/0.15.1"},{"title":"0.15.0","href":"/project/changelog/0.15.0"}]},{"group":"v0.14","expanded":false,"pages":[{"title":"0.14.1","href":"/project/changelog/0.14.1"},{"title":"0.14.0","href":"/project/changelog/0.14.0"}]},{"title":"Deprecated","href":"/project/changelog/deprecated"}]}]},{"group":"Resources","pages":[{"title":"Help and Support","href":"/project/support"},{"title":"Community","url":"https://paradedb.com/slack","href":"/project/resources/slack"},{"title":"Blog","url":"https://www.paradedb.com/blog","href":"/project/resources/blog"},{"title":"Learn","url":"https://www.paradedb.com/learn","href":"/project/resources/learn"}]}]}]}]},"basePath":"","title":"0.27.0 - ParadeDB","deploymentId":"dpl_J2QdBVuN65x4CCtpqPb371YPt4xi","buildId":"dpl_J2QdBVuN65x4CCtpqPb371YPt4xi","dynamics":["10e4515597"],"chunks":["BannerMarkdown-Cm-LN0H3.js","dist-DWEsd3cZ.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","katex-YMM-FMeD.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}