Verifying the tablespace storage for the Production Mapping 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.

List the tables and corresponding tablespace.

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

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

如果有任何表存储在错误的表空间中，则可使用 ALTER TABLE 和 ALTER INDEX 来更改表空间。