Odoo Help


how does --max-cron-threads parameter works in config file?

Anil R. Kesariya
on 5/19/17, 7:25 AM 1,235 views

Hello All,

How does --max-cron-threads works works config file?

How to resolve this issue?

conn = _connect(dsn, connection_factory=connection_factory, async=async) OperationalError: FATAL: sorry, too many clients already


Anil Kesariya


Serpent Consulting Services Pvt. Ltd.

--Serpent Consulting Services Pvt. Ltd.--
Serpent Consulting Services Pvt. Ltd.
| 6 6 8
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!

Serpent Consulting Services Pvt. Ltd.
On 5/19/17, 7:40 AM


It is for the maximum number of threads allowed to process cron jobs concurrently.

You may set it to zero for the cron jobs to disturb your other work/processes.

The error you get 'too many clients already' is the ability of postgresql and you have to configure it.


If you're using v10, the first thing I suggest is using Odoo with an upgraded PostgreSQL version, there has been a LOT of performance changes since 9.3, and now its even better in 9.6 with Parallel execution of sequential scans, joins and aggregates. That's first.

Then comes your configuration, which with 16GB should be near of this:

max_connections = 100

shared_buffers = 4GB

effective_cache_size = 12GB

work_mem = 41943kB

maintenance_work_mem = 1GB

checkpoint_segments = 64

checkpoint_completion_target = 0.9

wal_buffers = 16MB

default_statistics_target = 100

Serpent Consulting Services Pvt. Ltd., Serpent Consulting Services Pvt. Ltd.
on 5/19/17, 7:41 AM

Thank you very much. :)

Anil R. Kesariya
on 5/19/17, 7:49 AM


Lithin T
on 4/23/18, 5:11 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/19/17, 7:25 AM
Seen: 1235 times
Last updated: 12/5/17, 10:28 PM