The "pgsql_temp" directory is large.
search cancel

The "pgsql_temp" directory is large.

book

Article ID: 331173

calendar_today

Updated On:

Products

VMware Smart Assurance

Issue/Introduction

VM snap shot shows lots of data in the $VOYENCE_HOME/db/controldb/data/base/pgsql_temp directory.

Environment

NCM 10.x

Resolution

The NCM database has temp directory at:
 
$VOYENCE_HOME/db/controldb/data/base/pgsql_temp

This directory will grow and shrink through out the day depending on usage. The files are temporary and will be gone by the next day. So you can expect that one VM snap shot might be larger one day and another one smaller on another day. This is by design and is not considered a bug. 

Additional Information

If you notice files from previous days in the 

$VOYENCE_HOME/db/controldb/data/base/pgsql_temp

directory, please contact support as there might be another problem going on.