How to Move the WMX table JTX_JOB_ATTACHMENTS

MMBR

WMX attachments table "JTX_JOB_ATTACHMENTS" can grow very large.
The best practice is to move the table to its own filegroup / tablespace / datafile
to reduce fragmentation and contention, and to improve performance.

• PostgreSQL
• Oracle
• SQL Server

PostgreSQL

--create tablespaces

cd D:/postgresqldata/wmx
D:
mkdir wmx_att
mkdir wmx_att_index

DROP TABLESPACE wmx_att;
CREATE TABLESPACE wmx_att OWNER postgres LOCATION 'D:/postgresqldata/wmx/wmx_att';
DROP TABLESPACE wmx_att_index;
CREATE TABLESPACE wmx_att_index OWNER postgres LOCATION 'D:/postgresqldata/wmx/wmx_att_index';

GRANT CREATE ON TABLESPACE wmx_att TO wmx;
GRANT CREATE ON TABLESPACE wmx_att_index TO wmx;