<p><strong>TLDR:</strong> Amazon Aurora now supports PostgreSQL 18.3, bringing B-tree skip scans, statistics retention across major upgrades, and parallel logical replication streaming. Prisma Next benchmarks show ~50% higher peak throughput and p95 latency dropping from 41.8ms to 4.4ms at load, with a 9x smaller bundle. A deep comparative look at query planners across six databases — PostgreSQL, Oracle, DuckDB, Snowflake, MySQL, Db2 — is worth reading if you’ve ever wondered why Postgres ships zero query hints. Xata cut Postgres branch provisioning from 20+ seconds to 1-2 seconds using ZFS copy-on-write over NVMe-oF, making 1,000 short-lived branches cost roughly $1.</p>
<hr>
<h2>Amazon Aurora PostgreSQL 18.3 now available with skip scans and parallel logical replication</h2>
<p>Aurora PostgreSQL-Compatible now supports major version 18, starting at 18.3. The headline features for query performance are B-tree skip scans (useful for multi-column indexes where the leading column has low cardinality) and retention of optimizer statistics across major version upgrades — no more cold planner after an upgrade. Logical replication gets parallel streaming for large transactions, which directly reduces replication lag on write-heavy workloads. A new pg_roaringbitmap extension handles fast set operations on large integer collections, targeting audience segmentation and permission checks. Upgrade paths include RDS Blue/Green deployments, in-place upgrade, and snapshot restore. <a href="https://app.daily.dev/posts/F2VATMgdl" target="_blank" rel="noopener nofollow">Read more</a></p>
<h2>Prisma Next benchmarks: 50% more throughput, p95 latency down from 41.8ms to 4.4ms</h2>
<p>Prisma Next, the TypeScript-native rewrite currently in Early Access, hits ~12,500 req/s peak versus ~8,300 for Prisma 7 — about 50% higher throughput. More telling is the latency story: at 6,000-7,000 req/s, p95 drops from 41.8ms to 4.4ms, which is the difference between a noticeable hiccup and nothing. It now reaches 87% of raw pg driver throughput, up from 58%. Bundle size shrinks from 1.32MB to 148.5KB gzipped, which matters for serverless and edge. Prisma 7 remains the production recommendation for now. <a href="https://app.daily.dev/posts/SSSzV40UK" target="_blank" rel="noopener nofollow">Read more</a></p>
<h2>Query planner comparison across six databases: how join order search and hint exposure differ</h2>
<p>A thorough breakdown of how PostgreSQL, Oracle, Db2, MySQL, DuckDB, and Snowflake each search the join order space and how much control they hand back to users. Oracle and Db2 offer both sophisticated search and rich hint surfaces. DuckDB uses modern DPccp enumeration with minimal override. Snowflake removes all user controls entirely. MySQL is mid-migration from a greedy left-deep optimizer to a hypergraph-based one. PostgreSQL implements textbook System R dynamic programming and deliberately ships zero query hints — a principled stance the piece frames as rare and contested. Worth reading if you’ve ever reached for a hint in Postgres and found nothing there. <a href="https://app.daily.dev/posts/2eB26OBIC" target="_blank" rel="noopener nofollow">Read more</a></p>
<h2>Xata cuts Postgres branch provisioning to 1-2 seconds, 1,000 branches for $1</h2>
<p>Xata rebuilt branch provisioning using ZFS copy-on-write over NVMe-oF (their custom Xatastor storage layer) combined with warm pools of pre-provisioned Kubernetes pods. Branches were taking 20+ seconds; they now take 1-2 seconds. Because branches only store diffs to the parent and billing is per-minute with scale-to-zero, 1,000 short-lived branches run about $1. Real customers — AI coding agents and CI/CD preview environments — are running thousands of branches per week for under $30/month. The architecture separates compute from storage so volumes hot-connect to waiting pods in milliseconds. <a href="https://app.daily.dev/posts/NPf3LZD7k" target="_blank" rel="noopener nofollow">Read more</a></p>
<hr>
<h2>Also notable</h2>
<ul>
<li><strong>PostgreSQL default_statistics_target deep dive: per-column tuning beats global changes:</strong> Raising default_statistics_target globally slows ANALYZE across the board — the right move is per-column tuning via ALTER TABLE … ALTER COLUMN … SET STATISTICS, reserving the global change for analytics workloads only. <a href="https://app.daily.dev/posts/XQdZ6PrJ3" target="_blank" rel="noopener nofollow">Read more</a></li>
<li><strong>Databricks Spatial SQL GA: 90+ ST_ functions, up to 15x faster, Iceberg v3 geospatial types:</strong> Databricks Spatial SQL is now generally available with 90+ ST_ functions, up to 15x query speedups on some operations, native map visualizations in AI/BI dashboards, and Iceberg v3 interoperability with native geometry/geography types — GEOMETRY and GEOGRAPHY are also being contributed to Apache Spark 4.2 for summer 2026. <a href="https://app.daily.dev/posts/ta19gRY1T" target="_blank" rel="noopener nofollow">Read more</a></li>
<li><strong>Datadog and ClickHouse federated log querying now in Preview:</strong> Two new Preview features let teams route logs to ClickHouse via Datadog Observability Pipelines and query them directly from Log Explorer without re-ingesting into Datadog — relevant context given Datadog’s DASH announcements covered in yesterday’s digest. <a href="https://app.daily.dev/posts/ryDEd8SBE" target="_blank" rel="noopener nofollow">Read more</a></li>
<li><strong>lakeFS launches agentic AI data isolation: branch-scoped credentials, immutable audit trails, policy-gated merges:</strong> lakeFS for Agentic AI gives each agent an isolated zero-copy data sandbox with branch-scoped cryptographic credentials and policy-gated merges into production, directly addressing the class of incidents where agents wrote to production data with no rollback path. <a href="https://app.daily.dev/posts/Ckx5S1Rqz" target="_blank" rel="noopener nofollow">Read more</a></li>
<li><strong>npm v12 will disable install scripts and remote URL resolution by default; npm 11.16.0 previews the changes:</strong> npm 11.16.0 is available now to preview what v12 will block: preinstall/install/postinstall scripts and git/remote URL resolution will be off by default, a breaking change for any pipeline relying on those hooks. <a href="https://app.daily.dev/posts/G6Wf3GIB6" target="_blank" rel="noopener nofollow">Read more</a></li>
</ul>


Query optimization, schema design, and data store coverage across PostgreSQL, MongoDB, Redis, and more.

Databases Digest

A curated digest of database news: Amazon Aurora now supports PostgreSQL 18.3 with B-tree skip scans, statistics retention across upgrades, and parallel logical replication. Prisma Next benchmarks show ~50% higher throughput and p95 latency dropping from 41.8ms to 4.4ms, with a 9x smaller bundle. A comparative analysis covers query planner design across PostgreSQL, Oracle, DuckDB, Snowflake, MySQL, and Db2, explaining why Postgres ships no query hints. Xata cut Postgres branch provisioning from 20+ seconds to 1-2 seconds using ZFS copy-on-write over NVMe-oF, making 1,000 short-lived branches cost ~$1. Also covered: PostgreSQL statistics tuning, Databricks Spatial SQL GA, Datadog+ClickHouse federated log querying, lakeFS agentic AI data isolation, and npm v12 breaking changes.

Aurora PostgreSQL 18 lands, Prisma Next hits 50% faster throughput