Current default is set to 8. This is bad when running
on small machines; Perhaps the default should be set to
something like max(1, NumCPU()>>3)

Jira issue: CRDB-20321

Epic CRDB-24463