[VHRanger]

In memory, and if larger than memory it makes .duckdbtmp files to work from

[lolive]

So when you start doing crazy joins, a NVMe + big amount of RAM will really help DuckDB, in its work. Right?

[VHRanger]

correct!

And preferably a good nvme (not a cheap one without a DRAM cache) and good ram.