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