What DB type to select for Odoo optimization?

Question

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 c

Caitlyn Beasley · Answer

For most Odoo setups, the  * “Web application” *  profile in PGTune is a solid start. You can then tweak work_mem, shared_buffers, and autovacuum settings based on load.
If your XML-RPC sync is heavy, consider a separate worker or queue so it doesn't block web requests. Monitor for long queries and I/O limits — often the real gain comes from faster disks or splitting DB and app servers.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to disable "Add to Cart" button in E-commerce product page in Odoo 12? Ratkaistu ecommerce odoo12	5 lokak. 23	17036
when adding product to cart while accessing site with www I get catr is empty! ecommerce odoo12	0 kesäk. 20	3011
How to add a new Payment Acquirers in Odoo12 eCommerce Ratkaistu ecommerce odoo12	5 toukok. 20	5169
AttributeError: 'NoneType' object has no attribute '_get_first_possible_combination' ecommerce cart odoo12	0 lokak. 22	659
My Cart menu doesn't show up ecommerce cart odoo12	0 lokak. 22	379

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!