---
schema_version: "1"
id: e87e8b940cc19030d5c3ca054063327484f6c6f676d898a28120b3b376350cbe
title: Hardware Changes to RMT Server - Tuning PostgreSQL Database
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/server-linux/rmt-postgres-perf-tuning.md
canonical_url: https://help.tableau.com/current/server-linux/en-gb/rmt-postgres-perf-tuning.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 296aafea89214c65d1cdde672032c7a50f7d1410e0c704b5e43eba42e4b2f519
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 RMT Server, the setup program configures the PostgreSQL database to optimise the use of available hardware on the machine. Example optimisations 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 outside of working hours when the Resource Monitoring Tool is not in use.