postgresql move index to fast st

CREATE TABLESPACE fast_storage LOCATION '/some/ssd' WITH (random_page_cost=1);

ALTER INDEX <index name > SET TABLESPACE fast_storage;

上述方式将会锁表最好用pg_repack