Difference between revisions of "No Free Workers Error"

From Roaring Penguin
Jump to: navigation, search
Line 2: Line 2:
 
If you have not already, you should install PgBouncer as per Appendix G in the Administration Guide. This can greatly increase database performance.
 
If you have not already, you should install PgBouncer as per Appendix G in the Administration Guide. This can greatly increase database performance.
  
You can increase the maximum number of MIMEDefang processes as follows.
+
You can increase the maximum number of MIMEDefang processes by editing /etc/mail/canit/canit.conf and adjusting the:
 
 
First: Ensure that you have enough free memory using the 'free' command.
 
 
 
Each MIMEDefang process uses around 50MB of memory.
 
 
 
In the file /etc/postgresql/X.X/main/postgresql.conf (the X.X will be your PostgreSQL version number), there is a line for
 
 
 
  max_connections
 
 
 
the default of which is 100. This represents the total number or connections allowed to PostgreSQL, given by the sum of all MIMEDefang workers from all cluster members PLUS the number of expected simultaneous human connections. Thus, once you increase the max_connections, you will also need to increase the per-member connection limit by no more than ((new limit)-(old limit))/(number of nodes) using:
 
  
 
   mx_maximum=
 
   mx_maximum=
  
in the [mimedefang] section) of the /etc/mail/canit/canit.conf file.  
+
setting in the [mimedefang] section) of the /etc/mail/canit/canit.conf file. Make sure that you don't increase the maximum too much; each process uses about 50MB of memory.  Also, the sum of mx_maximum values cluster-wide should not exceed the max_connections PostgreSQL setting (if you are not using PgBouncer) or should not exceed it by a factor of more than 5 (if you are using PgBouncer).
  
 
<div style="float:right; clear:both; margin-right:0.5em">[[Support Wiki | [Home]]]</div>
 
<div style="float:right; clear:both; margin-right:0.5em">[[Support Wiki | [Home]]]</div>
 
[[category:All]][[category:Errors]]
 
[[category:All]][[category:Errors]]

Revision as of 10:23, 20 September 2018

If you have not already, you should install PgBouncer as per Appendix G in the Administration Guide. This can greatly increase database performance.

You can increase the maximum number of MIMEDefang processes by editing /etc/mail/canit/canit.conf and adjusting the:

 mx_maximum=

setting in the [mimedefang] section) of the /etc/mail/canit/canit.conf file. Make sure that you don't increase the maximum too much; each process uses about 50MB of memory. Also, the sum of mx_maximum values cluster-wide should not exceed the max_connections PostgreSQL setting (if you are not using PgBouncer) or should not exceed it by a factor of more than 5 (if you are using PgBouncer).