DocumentDB v0.117-0

This release improves aggregation correctness, collation support, query planning, and RUM index maintenance. Several query optimizations remain feature-flagged. Review the compatibility notes before deploying, especially for extension-only PostgreSQL installations.

Downloads and quick start

Changes

• _id selectivity: Estimate range and prefix filters as a merged range. Requires suitable schema operators and per-collection statistics or enableBsonSelectivityFromBtreeStats.
• Parallel aggregation: Fix crashes with the with-expression $min, $max, $first, and $last accumulators in parallel partial-aggregation plans.
• $mergeObjects: Ignore null and missing inputs; return an empty object when a group has no object inputs.
• RUM vacuum: Reclaim already-empty posting-tree leaf pages missed by earlier vacuum cycles, across the existing vacuum paths.
• $push: Preserve the full 64-bit range of $slice and $position, avoiding overflow and invalid array bounds.
• Pipeline correctness: Fix nested geospatial predicates and prevent output stages from writing root-pruned documents.
• Command validation: Clamp numeric options to prevent metadata constraint violations in collMod and divide-by-zero failures in $collStats.
• Parallel RUM scans: Preserve remaining entries on worker-owned pages and apply scalar-array skip bounds without bypassing shared page assignment.
• RUM split safety: Prevent vacuum from deleting either half of an incomplete split before its parent downlink is installed.
• Scalar $group: Add index scans for aggregates with a constant _id. documentdb.enable_scalar_aggregate_index_pushdown is off by default; accumulator path collection is independently controlled by documentdb.enable_scalar_aggregate_accumulator_path_collection.
• RUM default: Set documentdb.rum_library_load_option to require_documentdb_extended_rum on all supported PostgreSQL versions.
• $unwind planning: Extend projection pruning to pipelines with multiple $unwind stages, still guarded by enableProjectPushUpBeforeUnwindWithGroup.
• Composite indexes: Prefer leading-equality $elemMatch owners when choosing reduced-correlated bounds. Non-equality first-owner fallback remains off by default, controlled by documentdb.enable_composite_reduced_correlated_first_owner_fallback.
• Collated expressions: Make $max, $min, $maxN, and $minN collation-aware and correct equal-value selection for $maxN/$minN.
• Collated grouping: Support collation for $group keys.
• Collated index-only scans: Prevent projected queries from returning shared collation-equivalent index values instead of each row's stored values.
• Gateway observability: Make telemetry and metrics provider-neutral.

See the tagged changelog for implementation details and additional flag context.

Compatibility and upgrades

Extended RUM is now required by default on every supported PostgreSQL major. For manual extension-only installations, create documentdb_extended_rum as well as documentdb; CREATE EXTENSION documentdb CASCADE does not create it. The setup wizard handles this for managed installations. Setting documentdb.rum_library_load_option to none remains an opt-out.

Pre-GA upgrade policy: In-place package upgrades from earlier releases are not supported yet. Use a clean host, or remove previous DocumentDB packages first.

The documentdb meta package selects PostgreSQL 18. To install PG17, choose documentdb-17 and omit the meta package. Native gateway setup requires PG16 or newer; native PG15 packages are extension-only.

Downloads and quick start

Packages: Release assets | SHA256SUMS | Package inventory

The 22 attached packages cover PostgreSQL 17/18, Ubuntu 24.04 (DEB), and RHEL/Rocky 9 (RPM), on amd64/arm64. Download and verify the exact release:

gh release download v0.117-0 -R documentdb/documentdb -D pkgs \
  && cd pkgs \
  && sha256sum -c SHA256SUMS

Install only the matching platform and PostgreSQL package set together in one apt or dnf transaction. PostgreSQL and third-party dependencies are not included in these assets. Repository publication may follow the GitHub release; attached assets identify this exact build. Draft assets require authorized repository access until publication.

Containers: Official images support PostgreSQL 15-18 on linux/amd64 and linux/arm64. Use a versioned tag rather than floating latest:

docker pull ghcr.io/documentdb/documentdb/documentdb-local:pg17-0.117.0

Replace pg17 with pg15, pg16, or pg18 as needed. Docker selects the host architecture automatically. Use this versioned image when following the container quick start.

Setup guides: Linux quick start | Package Finder | Versioned package guide | Versioned container quick start

These guides cover prerequisites, complete install commands, authentication, persistent storage, optional sample data, and day-2 operations.