Been quite a fan of DuckDB and we actually even use it in production. But coinci...

yakkomajuri · 2026-01-16T21:04:41 1768597481

As far as I can tell pretty conclusive results:

If someone can explain this or has a fix for it I'd love to hear it!

fauigerzigerk · 2026-01-18T11:53:29 1768737209

You shouldn't expect a database system to release memory back to the OS just because it's no longer needed for some specific purpose.

DuckDB has a memory_limit setting with a default of 80% of RAM. If you want to set a lower limit you can do something like

SET memory_limit = '1GB';