Data and AI struggles

2,114 problems · 377 companies

Dev tooling

DuckDB feels slow and laggy

3 posts from 3 people3d activeRising, +2 this week

Posts per day

Posts per day3 posts, Oct 8 to Nov 21

The posts behind it

GitHub issuesduckdb/duckdb · OmarMohamed256Nov 17

Hive partition pruning is nearly 10x slower when filtering by day()/month() compared to dayofmonth()

### What happens? Pruning hive-partitioned files with a day() or month() filter costs up to 10x more per file than with dayofmonth(). year() is only slow for some filters. year(d) =, and >= are rewritten into a date range comparison, which is fast. IN, != and arithmetic are not...

GitHub issuesduckdb/duckdb · ChehaiNov 16

`NOT IN` with a long constant list is very slow

### What happens? `col IN (c1, …, cK)` with 5 or more constants is rewritten by the IN-clause rewriter into a hash join, so it stays fast as K grows, however `col NOT IN (c1, …, cK)` is not. When `K` is more than 500, `NOT IN` query latency can increase to more than 1 second,...

Companies and products named

3 posts
1 post
About this problem

Evidence

3 posts from 3 people in 2 places, about 1 a week over 41 days. Mostly on duckdb/duckdb, r/PostgreSQL. Tools named alongside: PostgreSQL, AppFolio.

Frustration Frustration 0 of 3· Seen on GitHub issues, Reddit

How it was grouped

Posts that state a pain and match the "slow-tool" rule about DuckDB. First post Oct 8, 2026, latest Nov 17, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

The same problem elsewhere

Everyday tools feel slow and laggy

26 posts from 26 people on Reddit, GitHub issues, Hacker News.

GitHub Copilot feels slow and laggy

9 posts from 9 people on Reddit, GitHub issues, Hacker News.

Claude feels slow and laggy

6 posts from 5 people on GitHub issues, Hacker News, Reddit.

PostgreSQL feels slow and laggy

5 posts from 5 people on Mastodon, Reddit, GitHub issues.

VS Code feels slow and laggy

4 posts from 4 people on GitHub issues.

SQL Server feels slow and laggy

4 posts from 4 people on Reddit, GitHub issues.

ChatGPT feels slow and laggy

4 posts from 4 people on Reddit, Hacker News, App Store reviews.

GitHub feels slow and laggy

3 posts from 3 people on GitHub issues.

Microsoft Teams feels slow and laggy

3 posts from 3 people on App Store reviews.

PyTorch feels slow and laggy

3 posts from 3 people on Reddit, GitHub issues.

OpenAI feels slow and laggy

3 posts from 3 people on GitHub issues.

AWS feels slow and laggy

3 posts from 3 people on Reddit, Mastodon.

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 queries run too slowly and are hard to tune

3 posts from 3 people on GitHub issues.

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

First seen with 3 posts.

Nov 21, 2026