test.sql

text/plain

Download

drop table if exists x;
create table x(f tsvector);
create index x_idx on x using gin(f);
insert into x (select 'test words taken at random but a few of them indeed' from generate_series(1, 500000) g);
vacuum;