"...but everybody is asking me to switch to PostgreSQL, ..."
https://docs.moodle.org/en/Arguments_in_favour_of_PostgreSQL
Hardware and performance
Moodle performance - examples of configurations
This discussion has been locked so you can no longer reply to it.