Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
26225 มุมมอง

Is there any proper documentation on how to configure and optimizer the Odoo server and PostgreSQL?

Like how to compute on the ff:

ODOO SERVER CONF

  • workers
  • limit_memory_hard
  • limit_memory_soft
  • limit_request 
  • limit_time_cpu 
  • limit_time_real 
  • max_cron_threads


POSTGRESQL.CONF

  • shared_buffers = 3072MB
  • effective_cache_size = 8192MB

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

Hello Aurelio,

Here's the configuration.

Server specs(Google Cloud Platform, 4cores,16GB)

=========================================

Odoo

to check cpu

cat /proc/cpuinfo | grep processor | wc -l

workers = (cores * 2) + 1


to check memory

cat /proc/meminfo | grep MemTotal | awk '{ print $2 }'

hard = 768MB

soft = 640MB


computation

limit_memory_hard = hard * 9workers * 1024 * 1024 

limit_memory_soft = soft * 9workers * 1024 * 1024



Odoo-server.conf

from 

#limit_memory_hard = 2684354560

#limit_memory_soft = 2147483648

to

limit_memory_hard = 7247757312

limit_memory_soft = 6039797760

=========================================

Postgresql


sudo nano /etc/postgresql/9.5/main/postgresql.conf 

here's the link to compute \https://pgtune.leopard.in.ua/#/


Postgresql.conf

max_connections = 100

shared_buffers = 4GB

effective_cache_size = 12GB

maintenance_work_mem = 1GB

checkpoint_completion_target = 0.9

wal_buffers = 16MB

default_statistics_target = 100

random_page_cost = 1.1

effective_io_concurrency = 200

work_mem = 20971kB

min_wal_size = 1GB

max_wal_size = 2GB

max_worker_processes = 4




อวตาร
ละทิ้ง

werd was here ;)

คำตอบที่ดีที่สุด

Hello Aurel Balanay,

for ODOO SERVER CONF you could refer this documentation https://www.odoo.com/documentation/13.0/setup/deploy.html#builtin-server

for POSTGRESQL.CONF use this https://pgtune.leopard.in.u

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
0
ธ.ค. 21
2364
2
ก.พ. 19
9520
7
ธ.ค. 18
8032
14
ธ.ค. 17
101042
0
ก.ย. 17
2541