This is controllable, but by default it makes one process per core. Regarding the pool size, I'd suggest that it should correspond more to how many simultaneou

This is controllable, but by default it makes one process per core. Regarding the pool size, I'd suggest that it should correspond more to how many simultaneous connections you think you'd have per process, so maybe just choose something like 32 to start with? Benchmarks would be required to find the sweet spot. To achieve true scalability you should use something like https://github.com/socketry/async-postgres https://github.com/socketry/async-postgres (/mysql) but this is a work in progress.