Performance issues with PostgreSQL processing data

[#1]

Those in medium to large-sized environments using PostgreSQL may experience performance or connection issues when processing data if the default connection pool size is used. By default, the connection pool size is set to 300 in FlexNet Manager for Engineering Applications, which works without issue in smaller environments. If you are experiencing connection issues and all other communication and access configurations are set correctly, try the steps below to increase the Database Connection Pool Size from 300 to 400.

Increase the Database Connection Pool Size

NOTE: This setting must be changed in the FlexNet Site Configurator for the Admin and Reporting servers and in PostgreSQL.

1. Stop FlexNet Manager for Engineering Applications Admin.

• To stop the Admin server from the command line, navigate to the Admin installation location, then type the command: flexnet stop

or

• If you configured the Admin server to run as a Windows service, you can stop the service from the Windows Services pane.

2. Open a Command Prompt window as an Administrator and go to admin_install_directory.
3. Type flexnet site to launch the Admin Configurator.
4. In step 4 of 6, enter “400” in the Database Connection Pool Size field.

5. Select Next, then Finish to save the settings. No restart is required. When you select Next and Finish on step 5, it rebuilds the configuration files.

• To start the Admin server from the command line, navigate to the Admin installation location, then type the command: flexnet service start

1.     or

• If you configured the Admin server to run as a Windows service, you can start the service from the Windows Services pane.

6. Stop FlexNet Manager for Engineering Applications Reporting.

• To stop the Reporting server from the command line, navigate to the Reporting installation location, then type the command: flexnet stop

or

• If you configured the Reporting server to run as a Windows service, you can stop the service from the Windows Services pane.

7. Open a Command Prompt window as an Administrator and go to reporting_install_directory.
8. Type the command flexnet site to launch the Reporting Configurator.
9. In step 4 of 6, enter “400” in the Database Connection Pool Size field.

10. Select Next, then Finish to save the settings. No restart is required. When you select Next and Finish on step 5, it rebuilds the configuration files.

• To start the Reporting server from the command line, navigate to the Admin installation location, then type the command: flexnet service start

10.     or

• If you configured the Reporting server to run as a Windows service, you can start the service from the Windows Services pane.

11. Check with your PostgreSQL database Admin on the current connection pool size configured on the database side. If it’s configured below 400, you will also need to increase this connection size. For more information, see the PostgreSQL article Connections and Authentication.
    

After updating these settings, performance and stability should improve in larger PostgreSQL environments.