Verifying the tablespace storage for the product library workspace in PostgreSQL

Доступно с лицензией Production Mapping.

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 modified previously, you can run the following script examples in pgAdmin or psql.

Примечание:

Copying and pasting the example may cause syntax errors.

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

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

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