Horton

gisttest2.sql

text/x-sql

Download
Filename: gisttest2.sql
Type: text/x-sql
Part: 0
Message: Re: GiST insert algorithm rewrite 
DROP TABLE IF EXISTS tt;
CREATE TABLE tt (a int4);
CREATE INDEX i_tt ON tt USING gist (a);

checkpoint;
INSERT INTO tt
SELECT i FROM generate_series(1, 200000) i;