Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
4006 Widoki

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?

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
5
paź 23
15896
0
cze 20
2416
5
maj 20
4430
0
paź 22
659
0
paź 22
379