projects
/
plantuner.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
forbid_index => disable_index. Introduce enable_index overloads disable_index
[plantuner.git]
/
sql
/
plantuner.sql
diff --git
a/sql/plantuner.sql
b/sql/plantuner.sql
index
91b9753
..
f0bda23
100644
(file)
--- a/
sql/plantuner.sql
+++ b/
sql/plantuner.sql
@@
-1,6
+1,6
@@
LOAD 'plantuner';
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 TABLE wow (i int, j int);
CREATE INDEX i_idx ON wow (i);
@@
-10,12
+10,18
@@
SET enable_seqscan=off;
SELECT * FROM wow;
SELECT * FROM wow;
-SET plantuner.
forbid
_index="i_idx, j_idx";
+SET plantuner.
disable
_index="i_idx, j_idx";
SELECT * FROM wow;
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;