Hi, we’ve been having some problems with error 502 coming up a lot. It happens mostly when people are trying to post and it has happened a few times doing other actions. Also, in the admin dashboard, I can’t get access to the posts stats, it says “this query is taking too long” and so on.
Could it be that the postgres is in need of some tuning? Or something with nginx?
I’ve already increased database buffers to 8gb and work_mem parameter to 100mb but it doesn’t really help. Remember that our database has almost 6 million posts and about 50-100 users online almost every time. Database is around 9gb and we are in a cloud server with 32gb RAM and about 50gb free disk space.