I have a Django application using Postgresql 9.3 that is about to grow in load to about 300 inserts per minute (peak load) and about 6 million rows per month in one table. Also there should be a lot of queries on that same table, nothing complicated, just a sum grouping by and indexed field.
Can anyone tell me how much hardware should I provide for this load or what would be a good way to handle this?
Thanks a lot.