Comment by mahogany
16 hours ago
Note that SET memory_limit is a soft limit and can be completely ignored for some tasks, so this wouldn’t be the same as having a limit on physical memory.
16 hours ago
Note that SET memory_limit is a soft limit and can be completely ignored for some tasks, so this wouldn’t be the same as having a limit on physical memory.
In past experience with DuckDB I have found this soft-limit distinction to be very important.