Hi there,
"The system is fine-tuned to exploit the large main memories of modern computer systems effectively and has proven to be highly efficient in data warehouse query processing.
NumaQ can easily scale to thousands of cores and terabytes of memory for data-intensive."
I wonder if there is a public documentation on how to configure large scale hardware for optimal MonetDB performance. So one could try setup NumaQ-like machine by using what you already learned.
"MonetDB is developed/tuned under two main assumptions:
- Your workload is analytical, i.e., you have lots of (grouped) aggregations and the like.
- Even more important: your hot dataset (the data that you actually work with) fits into the main memory of your system. MonetDB does not have it's own Buffer Manager but relies on the OS to handle disk I/O. Since the OS (especially windows but Linux too) is sometimes very dumb about disk swapping that may become a problem (especially for joins that run out of memory)."
Are there any official benchmarks for Windows vs Linux MonetDB performance (especially for queries that require disk swapping) ?
Thank you,
Anton