DBA Hub

📋Steps in this guide1/1

Move table/index to different tablespace

Move table/index to different tablespace

postgresql configurationintermediate
by PostgreSQL
12 views
1

Move table/index to different tablespace

Move table/index to different tablespace

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
-- 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!