Hardware Changes to RMT Server - Tuning PostgreSQL Database

Sometimes you may need to upgrade or change hardware on the machine where RMT Server is installed. Whenever you make any hardware changes, specifically to memory and CPU, it would be beneficial to tune the underlying PostgreSQL database that is installed with the RMT Server.

When you install RMTr Server, the setup program configures the PostgreSQL database to optimize the use of available hardware on the machine. Example optimizations include managing the buffer and cache size. When you change the hardware on your machine, it may affect the performance.

Use the following steps to make sure the configuration is updated to reflect the change in hardware:

  1. Open PowerShell command prompt. Run as an administrator.
  2. Navigate to the prerequisites directory under Tableau Resource Monitoring Tool. By default it is located at: C:\Program Files\Tableau Resource Monitoring Tool\prerequisites.

    cd C:\Program Files\Tableau Resource Monitoring Tool\master\

  3. Run the following command:

    .\tunePostgres.psl

    You should see a message that indicates that the configuration file has been updated. It will also state that a restart of the PostgreSQL service is required for the changes to take effect. The updates to the configuration file does not require downtime of the server.

  4. Restart the PostgreSQL database. You can do this during off-work hours when the Resource Monitoring Tool is not in use.