Hello!

We are running Odoo 18 (self-hosted) on our own server.

Server configuration:

• CPU: 12 vCPU
• RAM: 20 GB
• SSD: 500 GB
• PostgreSQL: 16
• Odoo:)

Situation:

• We have ~30 active users working simultaneously.
• Many users create large sales orders with 300+ order lines, sometimes even 500+ lines.
• When we set 12 Odoo workers → Odoo runs fast, but PostgreSQL logs show:

  psycopg2.errors.SerializationFailure: could not serialize access due to concurrent update
  
  

• When we reduce the workers to 4 → no errors, but Odoo becomes very slow, especially when working with big sales orders.

Question:

• How should we properly tune PostgreSQL and Odoo to:
  1. .
  2. Keep fast performance with large orders (300+ lines).
  3. Efficiently use 12 CPU and 20 GB RAM.
• Which PostgreSQL parameters should we optimize for Odoo?
• Do you have an example of a recommended postgresql.conf configuration for Odoo with 30+ concurrent users, 12 CPU, and large orders?

Thanks in advance for your help!