pg 快速创建索引

快速创建索引
show max_parallel_maintenance_workers;
postgres=# show max_parallel_maintenance_workers;
max_parallel_maintenance_workers
----------------------------------
2
(1 row)

set max_parallel_maintenance_workers to 4;

alter table t set (parallel_workers=4);

postgres=# show maintenance_work_mem;
maintenance_work_mem
----------------------
64MB
(1 row)

set maintenance_work_mem to '2 GB';

 

总结：使用并行+调整参数