We are now having problems trouble to tackle the intensive traffic to our servers during peak hours; see this related question on tuning the DB. At the moment we are using a smaller cloud service for the server hosting. Currently we are looking at the possibility to move our server to AWS. The problems we are having are mainly related to our database server and therefore we would like to have AWS-instance which is significantly better than the one we are using now.
The stats for the cloud server where the database server is located are as follows:
- 8 CORES
- 16GB RAM
- 100 GB, RAID-10 * SAS 15.000 RPM
Is there anything in particular you should think about when choosing what amazon instance to use for a PostgreSQL database server?