测试环境准备
最近更新时间: 2025-10-11 18:10:00
postgres=# create table t_trgm (id int,trgm text,no_trgm text) ;
CREATE TABLE
postgres=# \timing
Timing is on.
postgres=# insert into t_trgm select t,md5(t::text),md5(t::text) from generate_series(1,1000000) as t;
INSERT 0 1000000
Time: 4239.598 ms (00:04.240)postgres=#