---
schema_version: "1"
id: 4749bea2f20569c44b739d7212917f62a5621fc28547946643090cb45aa79871
title: Hardware Changes to RMT Server - Tuning PostgreSQL Database
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/server/rmt-postgres-perf-tuning.md
canonical_url: https://help.tableau.com/v0.0/server/en-us/rmt-postgres-perf-tuning.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 7e08063e24eddd1c0c6801d652136979e1c253b41f7ffb7d264d99e59e50fba0
description: Tune the RMT Server PostgreSQL database after hardware changes.
---
[Skip to main content](#main-content)

# 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.