X-Git-Url: http://www.sigaev.ru/git/gitweb.cgi?p=gevel.git;a=blobdiff_plain;f=sql%2Fgevel.sql;h=50bf184821e6b5e5eb47356e7a4bf0c16317ba40;hp=23aaa8cc36b36c055c3c290e55246d54c331c6ae;hb=1bf3b34c2a2f10e5147c8ba3fd6bf54b5692e35c;hpb=a61c2088be6a6f32e3ce6829e860bf2a431d5e05 diff --git a/sql/gevel.sql b/sql/gevel.sql index 23aaa8c..50bf184 100644 --- a/sql/gevel.sql +++ b/sql/gevel.sql @@ -22,5 +22,5 @@ CREATE INDEX gin_idx ON test__int USING gin ( a ); INSERT INTO test__int ( SELECT ARRAY[t] || '{1000}'::_int4 FROM generate_series (1,300) as t ); INSERT INTO test__int ( SELECT ARRAY[t] || '{1001}'::_int4 FROM generate_series (1,300) as t, generate_series(1,12) ); - +VACUUM ANALYZE test__int; SELECT * FROM gin_stat('gin_idx') as t(value int, nrow int);