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
Regards,
Anil Kesariya
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
19205
Views
Anil,
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.
Thanks.
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
Thank you very much. :)
(y)
