📋Steps in this guide1/1

Move table/index to different tablespace

postgresql configurationintermediate

by PostgreSQL

12 views

Move table/index to different tablespace

Code/Command (click line numbers to comment):

-- move table to different tablespace
prod_crm=#
alter table TEST8 set tablespace pg_crm;
ALTER TABLE
-- Move index to different tablespace
prod_crm=#
alter index TEST_ind set tablespace pg_crm;
ALTER TABLE

Comments (0)

Please to add comments

No comments yet. Be the first to comment!