测试环境准备
最近更新时间: 2024-06-12 15:06: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=#