DuckDB queries run too slowly and are hard to tune
3 posts from 3 people3d activeRising, +2 this week
Posts per day
The posts behind it
Use-after-free: collapsing a secure view leaves its operators in QueryProfiler’s tree map
### What happens? `CollapseSecureViews` folds a secure view's subtree onto its boundary node so that the profile does not show the operators inside the view: `tree_map` still holds the entry `CreateTree` inserted for each of those operators. The collapse removes them from the...
Correlated EXISTS with equality and <> (TPC-DS Q16/Q94/Q95 pattern) is 4x-17x slower in 2.0.0 than 1.5.6
### What happens? A correlated `EXISTS` with an equality plus a `<>` correlation (the pattern used by TPC-DS Q16, Q94 and Q95) is several times slower on DuckDB 2.0.0 than on 1.5.6 for the same data, with identical results. 1.5.6 plans a SEMI hash join with both conditions....
SELECT DISTINCT / GROUP BY on a VARIANT column is 10-15x slower than on the equivalent STRUCT: first() round-trips the physical VARIANT through create_sort_key (1.2 KB per row) on top of the variant_comparator collation key
### What happens? `SELECT DISTINCT v FROM t` over a VARIANT column holding a 28-field object (built with `struct_pack(...)::VARIANT`) on 1 M rows takes 9.4 s wall / 32 s CPU with 4 threads (39 s wall single-threaded), while the same query over the STRUCT column the VARIANT was...
Companies and products named
About this problem
Evidence
3 posts from 3 people in 1 place, about 1 a week over 38 days. Mostly on duckdb/duckdb. Tools named alongside: AWS.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "slow-queries" rule about DuckDB. First post Oct 13, 2026, latest Nov 19, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
The same problem elsewhere
PostgreSQL queries run too slowly and are hard to tune
10 posts from 10 people on Reddit, Stack Overflow, GitHub issues.
Queries run too slowly and are hard to tune
5 posts from 5 people on GitHub issues, Stack Overflow.
ClickHouse queries run too slowly and are hard to tune
3 posts from 2 people on GitHub issues.
Other DuckDB problems
DuckDB upgrades break working setups
55 posts from 42 people on GitHub issues.
Trouble with DuckDB join
Top post: "Wrong result: join_elimination drops a LEFT JOIN below a LIMIT/OFFSET under a DISTINCT", one of 12 posts from 11 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 21 posts from 16 people on GitHub issues.
DuckDB feels slow and laggy
3 posts from 3 people on GitHub issues, Reddit.
Trouble with DuckDB cast
Top post: "TRY_CAST of an empty BLOB to BIT escapes a non-fallible __cast and invalidates the database", one of 11 posts from 9 people on GitHub issues.
Trouble with DuckDB internal
Top post: "duckdb 2.0.0 fails to launch on BE: `INTERNAL Error: The time zone data is corrupt`", one of 20 posts from 12 people on GitHub issues.
DuckDB error messages are cryptic
12 posts from 8 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
11 posts from 7 people on GitHub issues.
DuckDB users keep filing bugs
Top post: "Support duckdb 2", one of 10 posts from 9 people on GitHub issues.
Trouble with DuckDB column
Top post: "2.0 alpha: comparing a CASE/split_part result to a constant fails with BindBuiltinScalarFunction did not", one of 8 posts from 5 people on GitHub issues.
Trouble with DuckDB null
Top post: "DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as", one of 7 posts from 7 people on GitHub issues.
Trouble with DuckDB values
Top post: "ManualVuln37 Unbounded Recursion in EncodeVariantValue Causes Stack Overflow via variant_comparator on Deeply", one of 7 posts from 7 people on GitHub issues.
History