Managing Temporary Tables

About Temporary Tables

Temporary tables are a feature of Greenplum Database and several other third-party DBMS vendors. In some circumstances temporary tables are created by processes but are not dropped. The console provides the temporary table maintenance module for listing temporary tables and dropping them to restore system resources.

Before using the temporary table maintenance module, you must configure the Greenplum Database connection. Select HPC Management

Temporary Table Maintenance

Module Config. The configuration parameters are identical to those described in Configuring the Greenplum Database Connection.

Viewing Temporary Tables

To view temporary tables:

Click HPC Management from the toolbar.
Click Temporary Table Maintenance.

Temporary Table Maintenance
Select the check box for a table to drop, and click Delete Tables to drop the tables.

Note: It is possible to drop a table that is in use. Make sure that the table that you have selected to drop is not in use. Perform this action during scheduled maintenance or after using some other method to ensure that the table is not in use.