Tuning PostgreSQL max_connections for Document Processing engine

Find details about estimating the max_connections required for Document Processing engine.

If you need to consider PostgreSQL max_connections for the entire IBM Automation Document Processing capability, see Tuning a PostgreSQL database for Content Platform Engine.

In PostgreSQL, the max_connections configuration option sets the maximum number of client connections that this server accepts. The number of database client connections that are required for the Document Processing engine base database and tenant databases can be estimated based on your deployment profile.

The following table provides the max_connections number per pod for all Document Processing engine components. The max_connections size for each component is as follows:
  • max_connections per pod * pod_number
You can sum up those numbers, and increase the sum by 10-20% to account for possible underestimates.
Table 1. Max connections per pod for Document Processing engine components
Document Processing engine component name Max Connections per pod
spbackend 27
setup 3
ocr-extraction 3
processing-extraction 3
classify process-classify 3
natural-language-extraction 3
postprocessing 3
wdu-extraction 3
cronjob 11