How to manage idle connections in PostgreSQL for Bold BI^®

Problem

Idle connections in the PostgreSQL database can impact the performance of Bold BI^®. 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 in 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 in 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 BI^®.

Additional References

• PostgreSQL Documentation: Configuration File
• Bold BI Official Website