Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Back Next

Tune the PostgreSQL Database

Perform configuration tasks to use a PostgreSQL database for the Model repository.

Ensure that the PostgreSQL installation has sufficient disk space for data files. By default, the files are in the directory

<PostgreSQL installation folder>/data

Ensure that the following properties are set in the PostgreSQL configuration file:

Set max_connectionsto 4000.

Set shared_buffers to 16GB.

Set max_locks_per_transaction to 1024.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.