postgresql move index to fast st

作者: lmy_8db4 | 来源:发表于2018-09-26 11:24 被阅读0次

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
上述方式将会锁表最好用pg_repack
How to Make Anyone Fall in Love
“Move fast” doesn’t mean making a beeline for your Quarry...
Linux Note 2 20160715
copy files and index move , rename file or index remove c...
postgres的一些资源汇总
1，pgbadgera fast PostgreSQL Log Analyzer http://dalibo.gi...
在 Elixir/Ecto 中使用 PostgreSQL JSO
Elixir PostgreSQL index JSON 索引 Ecto PostgreSQL 提供了丰富的数据类...
079：Get a move on. 赶快行动
June 1st 2018 /mu:v/移动，搬动; Get a move on. 赶快行动 Get a move...
冬日暖阳
Even if the pace is very small, we should move forward st...
日入一词_74：attribute
The fast access of the data that an index provides can be...
Sleep Sound:Good for you
Fall asleep fast to 10 categories of high-quality full-st...
Index parameters信息收集
Most USEARCH commands use a database index to enable fast...