test-gin-array.sql

application/sql

Filename: test-gin-array.sql

Type: application/sql

Part: 1

Message: Re: Reduce build times of pg_trgm GIN indexes

drop table if exists arraytbl;

create table arraytbl (iarr int[]);

insert into arraytbl select array_agg(i) from generate_series(1, 1000) i, generate_series(1, 100000) g  group by g;

\timing on

create index on arraytbl using gin (iarr);
create index on arraytbl using gin (iarr);
create index on arraytbl using gin (iarr);

\timing off