We’ve just started running some campaigns via SnapChat and traffic to the website is roughly around 80-200 concurrent connections. Above 60 concurrent connections it adds huge load to the Server/CPU and it shoots upto 80-90%. Not sure if this is related to an issue we experienced yesterday when the server went down for 5 minutes and this morning we started experiencing the CPU load.
Running some logs from the server seems to suggest it is something to do with Postgres. Are there any best practices for doing mainteance for Postgres (9.4) and are there any specific tools from within Matrix admin we can run to clear any stuck jobs related to DB and cache tables?
I did see quite a few posts on the forum but most go back to 2009 - 2011 so I’m wondering if they’re still valid guides to follow specially the Postgres commands?