CREATE TABLESPACE fast_storage LOCATION '/some/ssd' WITH (random_page_cost=1);
ALTER INDEX <index name > SET TABLESPACE fast_storage;
上述方式将会锁表最好用pg_repack
CREATE TABLESPACE fast_storage LOCATION '/some/ssd' WITH (random_page_cost=1);
ALTER INDEX <index name > SET TABLESPACE fast_storage;
上述方式将会锁表最好用pg_repack
本文标题：postgresql move index to fast st
本文链接：https://www.haomeiwen.com/subject/dfsdoftx.html
网友评论