diff options
Diffstat (limited to 'contrib/btree_gist/sql/btree_gist.sql')
| -rw-r--r-- | contrib/btree_gist/sql/btree_gist.sql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql index 31c778b7471..d6e564dda36 100644 --- a/contrib/btree_gist/sql/btree_gist.sql +++ b/contrib/btree_gist/sql/btree_gist.sql @@ -3,34 +3,35 @@ -- does not depend on contents of seg.sql. -- \set ECHO none +SET autocommit TO 'on'; \i btree_gist.sql \set ECHO all -create table inttmp (b int4); +CREATE TABLE inttmp (b int4); \copy inttmp from 'data/test_btree.data' -create table tstmp ( t timestamp without time zone ); +CREATE TABLE tstmp ( t timestamp without time zone ); \copy tstmp from 'data/test_btree_ts.data' -- without idx -select count(*) from inttmp where b <=10; +SELECT count(*) FROM inttmp WHERE b <=10; -select count(*) from tstmp where t < '2001-05-29 08:33:09'; +SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; -- create idx -create index aaaidx on inttmp using gist ( b ); +CREATE INDEX aaaidx ON inttmp USING gist ( b ); -create index tsidx on tstmp using gist ( t ); +CREATE INDEX tsidx ON tstmp USING gist ( t ); --with idx -set enable_seqscan=off; +SET enable_seqscan=off; -select count(*) from inttmp where b <=10; +SELECT count(*) FROM inttmp WHERE b <=10; -select count(*) from tstmp where t < '2001-05-29 08:33:09'; +SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; |