We use odoo 11 enterprise and postgre 9.6 with docker.

There are 15 users and about 100k products.

We are on a new server (64 GB RAM, 8 cores, SSD). odoo should run.

The normal work is going fast.

But the scheduler and some product filters (e.g. available products) take an eternity. (Scheduler > 1hour, available products 40 minutes)

We have made the following configurations (see below)

Does anyone know where the fault might be?

Thanks in advance.

odoo.conf

[options]

addons_path = /mnt/custom-addons

admin_passwd = xxxxxxx

csv_internal_sep = ,

data_dir = /var/lib/odoo

db_maxconn = 64

db_name = False

db_template = template1

db_user = odoo

dbfilter = .*

; debug_mode = False

; email_from = False

import_partial =

limit_memory_hard = 3750000000

limit_memory_soft = 3250000000

limit_request = 8192

limit_time_cpu = 600

limit_time_real = 1200

limit_time_real_cron = -1

list_db = True

; log_db = False

; log_handler = [':INFO']

;log_level = debug

; logfile = None

longpolling_port = 8072

max_cron_threads = 2

netprc_interface = odoo-web

osv_memory_age_limit = 1.0

osv_memory_count_limit = False

proxy_mode = True

server_wide_modules = web

smtp_password = False

smtp_port = 25

smtp_server = odoo-web

smtp_ssl = True

smtp_user = False

translate_modules = ['all']

unaccent = False

workers = 4

xmlrpc = True

xmlrpc_interface = odoo-web

xmlrpc_port = 8069

xmlrpcs = True

xmlrpcs_interface = odoo-web

xmlrpcs_port = 8071

postgresql.conf