X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=plantuner.git;a=blobdiff_plain;f=sql%2Fplantuner.sql;h=ddd6fcc94f1504faa518961600c08fe9e6a7c182;hp=91b97530c7d34b0948d814b5c3469759a2576acb;hb=ecc61f2bf65d40d144e394dc228e9f93d865776e;hpb=176da910e8225a413bac8992e650507f10f9b9d1

diff --git a/sql/plantuner.sql b/sql/plantuner.sql
index 91b9753..ddd6fcc 100644
--- a/sql/plantuner.sql
+++ b/sql/plantuner.sql
@@ -1,21 +1,51 @@
 LOAD 'plantuner';
 
-SHOW	plantuner.forbid_index;
+SHOW	plantuner.disable_index;
 
 CREATE TABLE wow (i int, j int);
 CREATE INDEX i_idx ON wow (i);
 CREATE INDEX j_idx ON wow (j);
+CREATE INDEX i1 ON WOW (i);
+CREATE INDEX i2 ON WOW (i);
+CREATE INDEX i3 ON WOW (i);
 
 SET enable_seqscan=off;
 
 SELECT * FROM wow;
 
-SET plantuner.forbid_index="i_idx, j_idx";
+SET plantuner.disable_index="i_idx, j_idx";
 
 SELECT * FROM wow;
 
-SHOW plantuner.forbid_index;
+SHOW plantuner.disable_index;
 
-SET plantuner.forbid_index="i_idx, nonexistent, public.j_idx, wow";
+SET plantuner.disable_index="i_idx, nonexistent, public.j_idx, wow";
 
-SHOW plantuner.forbid_index;
+SHOW plantuner.disable_index;
+
+SET plantuner.enable_index="i_idx";
+
+SHOW plantuner.enable_index;
+
+SELECT * FROM wow;
+--test only index
+RESET plantuner.disable_index;
+RESET plantuner.enable_index;
+
+SET enable_seqscan=off;
+SET enable_bitmapscan=off;
+SET enable_indexonlyscan=off;
+
+SET plantuner.only_index="i1";
+SHOW plantuner.only_index;
+
+EXPLAIN (COSTS OFF) SELECT * FROM wow WHERE i = 0;
+
+SET plantuner.disable_index="i1,i2,i3";
+EXPLAIN (COSTS OFF) SELECT * FROM wow WHERE i = 0;
+
+SET plantuner.only_index="i2";
+EXPLAIN (COSTS OFF) SELECT * FROM wow WHERE i = 0;
+
+RESET plantuner.only_index;
+EXPLAIN (COSTS OFF) SELECT * FROM wow WHERE i = 0;