ArangoDB memory overflow - is there no solution?

Question

When I perform AQL queries, I run into this error:

Query: AQL: query would use more memory than allowed (while executing)

My dataset: 9 billion vertices, 19 billion edges

My cluster has three nodes, running Centos 7 with 32 GB RAM

I only hope that the query can be executed and will not be reported wrong. What configuration files can be modified to achieve the purpose? I am new to ArangoDB.

Answer 1

Some back-of-the-envelope calculations suggest you will need to use the RocksDB engine:

(100 * 28 * 10^9) / (3 * (32 * 10^9)) => 29.17

See https://www.arangodb.com/why-arangodb/comparing-rocksdb-mmfiles-storage-engines/