---
schema_version: "1"
id: b69eabc925a903866bd51765238fb3d14ac7b954b462e3ab5ae163a64f8d6458
title: Hardware Changes to RMT Server - Tuning PostgreSQL Database
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/server-linux/rmt-postgres-perf-tuning.md
canonical_url: https://help.tableau.com/current/server-linux/en-us/rmt-postgres-perf-tuning.htm
source_site: help.tableau.com
content_type: documentation
content_hash: a82af0970d7218bce82b99596270839b2bf8596a333418293ca658312502070d
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. Connect to the RMT Server as a user with complete sudo access.
2. Navigate to the "master" directory and run the following command:
    
    `sudo /opt/tableau/tabrmt/master/tabrmt-master optimize`
    
    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.
3. Restart the PostgreSQL database. You can do this during off-work hours when the Resource Monitoring Tool is not in use.