<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd" -->

---
title: Announcing DuckDB 1.5.6 | daily.dev
description: DuckDB 1.5.6 has shipped as the seventh patch release in the 1.5 (Variegata) line, bundling bugfixes, performance improvements, and security patches....
canonical: https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: Announcing DuckDB 1.5.6 | daily.dev
og:description: DuckDB 1.5.6 has shipped as the seventh patch release in the 1.5 (Variegata) line, bundling bugfixes, performance improvements, and security patches....
og:url: https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd
og:image: https://api.daily.dev/og/posts/JUV4NsIjD.png
og:image:alt: Announcing DuckDB 1.5.6
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Announcing DuckDB 1.5.6

**[DuckDB](https://daily.dev/sources/duckdb)** · 2 min read · 72 upvotes · 5 comments

## Summary

DuckDB 1.5.6 has shipped as the seventh patch release in the 1.5 (Variegata) line, bundling bugfixes, performance improvements, and security patches. Highlights include fixes for crashes and internal errors (deadlocks, segfaults, concurrent ALTER/INSERT crashes), correctness fixes for min/max stats on decimal columns, generic bugfixes such as an ALTER TABLE ADD COLUMN regression and DROP COLUMN metadata corruption, a performance improvement enabling ALP/ALP_RD compression for smaller block sizes, and miscellaneous additions like ADBC Statistics API support and improved HTTP logging. The team also teases DuckDB v2.0.0 arriving in October.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://duckdb.org/2026/09/28/announcing-duckdb-156.html>

## Questions this post answers

### What does the DuckDB 1.5.6 release fix?

DuckDB 1.5.6, the seventh patch release in the 1.5 (Variegata) line, fixes several crashes and internal errors including a deadlock in the TemporaryMemoryManager, a segfault in the external hash aggregate, a concurrent ALTER and INSERT crash, and a C API scalar bind subquery crash. It also patches a min/max aggregate stats bug that caused crashes when row groups were filtered, plus generic bugfixes like an ALTER TABLE ADD COLUMN IF NOT EXISTS regression and DROP COLUMN metadata corruption.

_Track DuckDB patch releases like this on daily.dev before upgrading a production data pipeline._

### Does DuckDB 1.5.6 include any performance improvements?

Yes, DuckDB 1.5.6 enables the ALP and ALP_RD compression algorithms for storage version v1.5.0 and up when using smaller block sizes, improving compression efficiency for those configurations. This is listed as the sole performance-focused fix in the release, alongside a separate fix for an eviction node memory leak when using external files.

_Data engineers tuning DuckDB storage settings can follow release details like this on daily.dev._

### When is DuckDB 2.0.0 expected to release?

DuckDB v2.0.0 is planned for October, following the 1.5 (Variegata) line which reached its seventh patch release at 1.5.6. No exact date or feature list for 2.0.0 was given beyond this timing.

_Keep an eye on major DuckDB version jumps like this on daily.dev before planning an upgrade._

## Community discussion

Top comments from developers on daily.dev.

**@trevorsuna** · 1 upvotes

> This patch is a good reminder that a maintenance release still needs production-shaped validation. The decimal stats and concurrent ALTER/INSERT fixes touch correctness, not just polish; I’d replay representative queries and schema changes on a snapshot before treating 1.5.6 as a routine upgrade.

**@agustinbarrientos** · 1 upvotes

> The Windows preview looks worth trying on a machine with less RAM. How much of the speedup survives when the dataset can't fit in memory?

**@ahmetozel** · 0 upvotes

> The Windows table is more informative than the total speedup alone. Query 18 falls from roughly 230 seconds to 11, while query 3 rises from about 4.3 to 8.8 seconds. A workload dominated by the latter can regress even though the full TPC-H suite becomes much faster. I would weight the per-query results by the application’s observed query mix before estimating its benefit.
>
> The second-run methodology also describes a warm execution result, so startup and first-use latency remain separate questions. Keeping the exact development build in the comparison matters while those regressions are being...

**@ristotoldsep** · 0 upvotes

> Crash and correctness fixes? Honestly, these are the release notes I like.

## Similar posts on daily.dev

- [Announcing DuckDB 1.5.5](https://daily.dev/posts/announcing-duckdb-1-5-5-getayszp6) · DuckDB · 50 upvotes · 2 comments
- [Announcing DuckDB 1.5.4 Variegata](https://daily.dev/posts/announcing-duckdb-1-5-4-variegata-58idu4s19) · DuckDB · 74 upvotes · 1 comments
- [DuckDB 1.5 is Faster and Easier than Ever](https://daily.dev/posts/duckdb-1-5-is-faster-and-easier-than-ever-9a69bd0zb) · MotherDuck · 68 upvotes · 0 comments
- [Announcing DuckDB 1.5.1](https://daily.dev/posts/announcing-duckdb-1-5-1-wr87gvn0n) · DuckDB · 6 upvotes · 0 comments

---

Tags: [#performance](https://daily.dev/tags/performance), [#backend](https://daily.dev/tags/backend), [#duckdb](https://daily.dev/tags/duckdb)

[View this post on daily.dev](https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"Announcing DuckDB 1.5.6","url":"https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd"},"datePublished":"2026-09-28T13:52:49.287Z","dateModified":"2026-09-28T13:53:14.510Z","description":"DuckDB 1.5.6 has shipped as the seventh patch release in the 1.5 (Variegata) line, bundling bugfixes, performance improvements, and security patches....","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/21e13ee37c73cfbe866528c978e6501f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/21e13ee37c73cfbe866528c978e6501f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"DuckDB","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"DuckDB","logo":"https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb","url":"https://daily.dev/sources/duckdb"},"commentCount":5,"discussionUrl":"https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":72},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":5}],"keywords":"performance,backend,duckdb","timeRequired":"PT2M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DuckDB","item":"https://daily.dev/sources/duckdb"},{"@type":"ListItem","position":3,"name":"Announcing DuckDB 1.5.6"}]}
{"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd","comment":[{"@type":"Comment","text":"This patch is a good reminder that a maintenance release still needs production-shaped validation. The decimal stats and concurrent ALTER/INSERT fixes touch correctness, not just polish; I’d replay representative queries and schema changes on a snapshot before treating 1.5.6 as a routine upgrade.","datePublished":"2026-10-01T06:21:09.305Z","url":"https://daily.dev/posts/JUV4NsIjD#c-biupxXIKo","author":{"@type":"Person","name":"Trevor Suna","url":"https://daily.dev/trevorsuna","image":"https://media.daily.dev/image/upload/s--dZ7gXxpp--/f_auto/v1784081551/avatars/avatar_EMoP47rpuw8DNjhp6R1b6?_a=BAMAMicg0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"The Windows preview looks worth trying on a machine with less RAM. How much of the speedup survives when the dataset can’t fit in memory?","datePublished":"2026-10-01T22:32:11.433Z","url":"https://daily.dev/posts/JUV4NsIjD#c-xaBNMyumy","author":{"@type":"Person","name":"Agustin Barrientos","url":"https://daily.dev/agustinbarrientos","image":"https://media.daily.dev/image/upload/s--5ayxQnqn--/f_auto/v1788281802/avatars/avatar_wQYYVe5Tbj0NJ7C7qPoa8?_a=BAMAMicg0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"The Windows table is more informative than the total speedup alone. Query 18 falls from roughly 230 seconds to 11, while query 3 rises from about 4.3 to 8.8 seconds. A workload dominated by the latter can regress even though the full TPC-H suite becomes much faster. I would weight the per-query results by the application’s observed query mix before estimating its benefit.\nThe second-run methodology also describes a warm execution result, so startup and first-use latency remain separate questions. Keeping the exact development build in the comparison matters while those regressions are being fixed. The published table gives readers enough detail to choose representative queries rather than transferring the headline directly to every Windows deployment.","datePublished":"2026-10-06T18:37:26.265Z","url":"https://daily.dev/posts/JUV4NsIjD#c-xWXPeNG5O","author":{"@type":"Person","name":"Ahmet Özel","url":"https://daily.dev/ahmetozel","image":"https://avatars.githubusercontent.com/u/70992231?v=4"}},{"@type":"Comment","text":"Crash and correctness fixes? Honestly, these are the release notes I like.","datePublished":"2026-10-01T11:37:33.089Z","url":"https://daily.dev/posts/JUV4NsIjD#c-4vnaCqaA4","author":{"@type":"Person","name":"Risto Tõldsep","url":"https://daily.dev/ristotoldsep","image":"https://lh3.googleusercontent.com/a/ACg8ocLDWc6mZn0JwNmXXw6WY0L_HJ6pegzRttooC5VgtXESHSj3MNYx=s96-c"}}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/announcing-duckdb-1-5-6-juv4nsijd#faq","mainEntity":[{"@type":"Question","name":"What does the DuckDB 1.5.6 release fix?","acceptedAnswer":{"@type":"Answer","text":"DuckDB 1.5.6, the seventh patch release in the 1.5 (Variegata) line, fixes several crashes and internal errors including a deadlock in the TemporaryMemoryManager, a segfault in the external hash aggregate, a concurrent ALTER and INSERT crash, and a C API scalar bind subquery crash. It also patches a min/max aggregate stats bug that caused crashes when row groups were filtered, plus generic bugfixes like an ALTER TABLE ADD COLUMN IF NOT EXISTS regression and DROP COLUMN metadata corruption. Track DuckDB patch releases like this on daily.dev before upgrading a production data pipeline."}},{"@type":"Question","name":"Does DuckDB 1.5.6 include any performance improvements?","acceptedAnswer":{"@type":"Answer","text":"Yes, DuckDB 1.5.6 enables the ALP and ALP_RD compression algorithms for storage version v1.5.0 and up when using smaller block sizes, improving compression efficiency for those configurations. This is listed as the sole performance-focused fix in the release, alongside a separate fix for an eviction node memory leak when using external files. Data engineers tuning DuckDB storage settings can follow release details like this on daily.dev."}},{"@type":"Question","name":"When is DuckDB 2.0.0 expected to release?","acceptedAnswer":{"@type":"Answer","text":"DuckDB v2.0.0 is planned for October, following the 1.5 (Variegata) line which reached its seventh patch release at 1.5.6. No exact date or feature list for 2.0.0 was given beyond this timing. Keep an eye on major DuckDB version jumps like this on daily.dev before planning an upgrade."}}]}
```