I am using 5.1.0 with a single node(docker), running on 16 vCPUs, 64GB RAM. The config params as below:
NEO4J_server_memory_pagecache_size=27g
NEO4J_server_memory_heap_initial__size=23g
NEO4J_server_memory_heap_max__size=23g
NEO4J_db_memory_pagecache_warmup_preload=true
NEO4J_server_memory_pagecache_scan_prefetchers=32
I also have one Btree index on the nodes. Attached is the query profile. Please help to suggest why the operators always result in dbhits and never use the pagecache, There is a big performance impact because of this...