There are lots of row modifications (several thousands of rows per minute) in our PostgreSQL database that stores transactional data. We have a problem because PostgreSQL runs vacuuming process and this very slow down our database performance. I am looking for the most efficient solution how to solve this problem. Could be a solution some of these points?:
- Separate these transactional data into another PostgreSQL database?
- Change PostgreSQL for MySQL for better performance?