gisttest.sql

text/x-sql

Filename: gisttest.sql

Type: text/x-sql

Part: 1

Message: Re: GiST insert algorithm rewrite

DROP TABLE IF EXISTS tt;
CREATE TABLE tt (a tsvector);
CREATE INDEX i_tt ON tt USING gist (a);

checkpoint;
INSERT INTO tt
SELECT (chr(97+(i%27)) || chr(97+(i%29)) || repeat(chr(97+(i%23)), (i%11) + 1))::tsvector AS a
FROM generate_series(1, 200000) i;