Managing Idle Connections in PostgreSQL for Bold Reports

Problem

Idle connections in the PostgreSQL database can impact the performance of Bold Reports. To address this issue, it is necessary to clean up idle connections.

Solution

To close idle connections in the PostgreSQL database, you can add a timeout for idle connections. Follow the steps below:

1. Run the following command on the PostgreSQL server to set the idle connection timeout:

   ALTER SYSTEM SET idle_in_transaction_session_timeout='15s';
   

2. Restart the PostgreSQL server.

3. To verify if the timeout has been added properly, run the following query on the server:

    SHOW idle_in_transaction_session_timeout;
   

By setting the idle_in_transaction_session_timeout parameter, idle connections will be closed automatically after the specified time, improving the performance of Bold Reports.

Additional References

• PostgreSQL Documentation: Configuration File
• Bold Reports Official Website