I'm trying to up a self-hosted Forem community on Studyhab.com on DigitalOcean.
I have some problems with Forem for that project:
StudyHab contains over 5 million articles, 10 million comments, and 2 million users. Its Postgresql database is a database service with 8 GB RAM, 4 vCPU, 115 GB Disk configuration on DigitalOcean, too. As you can see here, Forem is too slow with this database, and I couldn't find a solution to improve Forem's performance.
Although I have tried to use Fastly with its API service and added the API Key and Service ID in rails.env file, Forem didn't work on Fastly.
What can I do about these problems? Do you have a suggestion for dealing with this size of a database?