KNOWLEDGE BASE

High Disk Consumption Due to Large pgsql_tmp in the Repository


Published: 15 Mar 2018
Last Modified Date: 15 Mar 2018

Issue

Very high disk utilization (30GB or more) due to large pgsql_temp folder.
 

 

Environment

  • Tableau Server 

Resolution

  1. Stop using custom admin view with direct access to the repository database.
  2. Reduce the size of historical tables. 

Cause

The issue is caused by the custom admin view for a large historical data set with userID set to "readonly". 
Did this article resolve the issue?