OSDN > Find Software > Use planner hints on PostgreSQL > SCM > git > pg_hint_plan > Commit

Use planner hints on PostgreSQL
Fork

pg_hint_plan: Commit

firtst release

Revision	78f932310a1390e5ac5f5ea8eadb5d6b2cc3136d (tree)
Time	2013-08-09 16:33:56
Author	Takashi Suzuki <suzuki.takashi@metr...>
Commiter	Takashi Suzuki

ヒント用テーブルにヒント検索高速化用のインデックスを作成した。

--- a/expected/ut-A-9.1.out

+++ b/expected/ut-A-9.1.out

		@@ -181,6 +181,7 @@ SET pg_hint_plan.enable_hint_table TO on;
181	181	hints \| text \| not null
182	182	Indexes:
183	183	"hints_pkey" PRIMARY KEY, btree (id)
	184	+ "hints_norm_and_app" UNIQUE, btree (norm_query_string, application_name)
184	185
185	186	----
186	187	---- No. A-6-2 search condition

--- a/expected/ut-A-9.2.out

+++ b/expected/ut-A-9.2.out

		@@ -181,6 +181,7 @@ SET pg_hint_plan.enable_hint_table TO on;
181	181	hints \| text \| not null
182	182	Indexes:
183	183	"hints_pkey" PRIMARY KEY, btree (id)
	184	+ "hints_norm_and_app" UNIQUE, btree (norm_query_string, application_name)
184	185
185	186	----
186	187	---- No. A-6-2 search condition

--- a/pg_hint_plan--1.0.sql

+++ b/pg_hint_plan--1.0.sql

		@@ -10,3 +10,7 @@ CREATE TABLE hint_plan.hints (
10	10	hints text NOT NULL,
11	11	PRIMARY KEY (id)
12	12	);
	13	+CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
	14	+ norm_query_string,
	15	+ application_name
	16	+);