创建索引消耗时间

最近更新时间: 2025-10-11 18:10:00

postgres=# create index t_trgm_trgm_idx on t_trgm using gist(trgm gist_trgm_ops);  
CREATE INDEX
Time: 24974.600 ms (00:24.975)
postgres=# 
postgres=# vacuum ANALYZE t_trgm;
VACUUM
Time: 551.989 ms