Verifying the tablespace storage for the Workflow Manager (Classic) workspace in PostgreSQL

Available with Workflow Manager license.

Ensure that the workspace was created under the correct tablespace for proper data storage and the reduction of disk contention. Using the DBTUNE configuration that you previously modified, you can run the following script examples in pgAdmin or psql.

Note:

Copying and pasting the examples may cause syntax errors.

List the tables and corresponding tablespace.

select schemaname, tableowner, tablename, tablespace
from pg_tables
  where tableowner = 'wmx'
  order by schemaname, tableowner, tablename, tablespace;

select schemaname, tablename, indexname, tablespace
from pg_indexes
  where schemaname = 'wmx'
  order by schemaname, tablename, indexname, tablespace;

If any tables are stored in the wrong tablespace, ALTER TABLE and ALTER INDEX can be used to change the tablespace.