AWS aurora-dsql: Release notes for partial indexes and batched nested-loop joins
Summary
Adds a September 2026 section announcing partial index support (CREATE INDEX with WHERE predicate) and batched nested-loop join support with the dsql.enable_batched_nestloop session parameter.
Security assessment
Release notes for query-planner and index features are purely functional/performance announcements; no security control, vulnerability fix, or credential/encryption change is described.
Evidence
+✨ _Feature_ — **Batched nested-loop joins** — Aurora DSQL can now use batched nested-loop joins for eligible queries. This join strategy batches multiple outer rows and probes the inner side for the batch, which can reduce round trips between the compute and storage layers for selective joins. In EXPLAIN output, this node appears as `Nested Loop (Batched Join)`. You can enable or disable planner use in a session with `dsql.enable_batched_nestloop`. For more information, see [Batched nested-loop joins in Aurora DSQL EXPLAIN plans](batched-nested-loop-joins.html).
Diff
diff --git a/aurora-dsql/latest/userguide/release-notes.md b/aurora-dsql/latest/userguide/release-notes.md index 60d86e5b1..d7e2a4745 100644 --- a//aurora-dsql/latest/userguide/release-notes.md +++ b//aurora-dsql/latest/userguide/release-notes.md @@ -14,0 +15,12 @@ This page describes new features, service launches, and important updates for Au +### September 2026 + +September 15, 2026 + + +🐘 _PostgreSQL Compatibility_ — **Partial indexes** — Aurora DSQL now supports partial indexes. Add a `WHERE` clause to `CREATE INDEX` to index only the rows that satisfy a predicate, tailoring the index to common query filter patterns. Aurora DSQL can use a partial index for a query when it can prove that the query's `WHERE` conditions imply the index's predicate. For more information, see [CREATE INDEX](create-index-syntax-support.html). + +September 11, 2026 + + +✨ _Feature_ — **Batched nested-loop joins** — Aurora DSQL can now use batched nested-loop joins for eligible queries. This join strategy batches multiple outer rows and probes the inner side for the batch, which can reduce round trips between the compute and storage layers for selective joins. In EXPLAIN output, this node appears as `Nested Loop (Batched Join)`. You can enable or disable planner use in a session with `dsql.enable_batched_nestloop`. For more information, see [Batched nested-loop joins in Aurora DSQL EXPLAIN plans](batched-nested-loop-joins.html). +