X-Git-Url: http://www.sigaev.ru/git/gitweb.cgi?p=plantuner.git;a=blobdiff_plain;f=sql%2Fplantuner.sql;fp=sql%2Fplantuner.sql;h=f0bda23833c3c651a99edb62af77e3a91da3bb7b;hp=91b97530c7d34b0948d814b5c3469759a2576acb;hb=6c66d17a2dc6e5372e0136ae495370a359a3f913;hpb=36d26353024f2b144058cbf788385dd1ef339b05 diff --git a/sql/plantuner.sql b/sql/plantuner.sql index 91b9753..f0bda23 100644 --- a/sql/plantuner.sql +++ b/sql/plantuner.sql @@ -1,6 +1,6 @@ LOAD 'plantuner'; -SHOW plantuner.forbid_index; +SHOW plantuner.disable_index; 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; -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;