Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
4005 Näkymät

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?

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
5
lokak. 23
15896
0
kesäk. 20
2416
5
toukok. 20
4430
0
lokak. 22
659
0
lokak. 22
379