I'm trying to optimize my odoo server. I don't know in PGTune what DB type to select. The server is for hosting eCommerce websites, but it syncs data from a pos terminal. So all customers and products get created/updated in odoo trough xmlrpc calls.
The initial sync runs from a few seconds (below 1000) to a few hours (above 20000) depending on the number of products.
The sync just eats all the resources of the server so the websites are slow in responding. I think it's because of my postgresql configuration.
I have configured workers and cpu_limits. Postgres is configured for type Web application but I don't think this is the best configuration.
What DB Type should I select in PGTune for my needs?
Can I limit the resources that are used for xmlrpc calls?
