Hello,
our company's intranet is odoo-based, but right now we have postgres and odoo in the same machine and we're having some performance issues, so we want to change that.
We're thinking about two options mainly, have two amazon servers (EC2 for odoo and RDS for postgres) or have two separate VMs in our company. Which one would be the better option in theory?
We would also like to do some stress-testing in both cases, is there any odoo module for that?
Thank you
Which theory? For both options there are plenty of theories...
I've heard (but have no experience or specific knowledge) that RDS doesn't give you enough low level control over PostgreSQL - specifically to the kinds of low level performance tweaks you would want for Odoo if performance becomes a problem.