تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
4000 أدوات العرض

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?

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
5
أكتوبر 23
15894
0
يونيو 20
2406
5
مايو 20
4429
0
أكتوبر 22
659
0
أكتوبر 22
379