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

Use planner hints on PostgreSQL
Fork

R/O
HTTP
SSH
HTTPS

pg_hint_plan: Commit

firtst release

Commit MetaInfo

Revision	24d844efcc23aac6fd9da105008f17f74e1581d2 (tree)
Time	2020-02-13 15:50:38
Author	Kyotaro Horiguchi <horikyota.ntt@gmai...>
Commiter	Kyotaro Horiguchi

Log Message

Stabilize regression test.

Further unstability is found about stats reset. Inserted more 1 second
sleeps to stabilize it.

Change Summary

modified: expected/pg_hint_plan.out (diff)
modified: sql/pg_hint_plan.sql (diff)

Incremental Difference

--- a/expected/pg_hint_plan.out

+++ b/expected/pg_hint_plan.out

		@@ -8201,6 +8201,12 @@ END;
8201	8201	$$ VOLATILE LANGUAGE plpgsql;
8202	8202	vacuum analyze t1;
8203	8203	SET pg_hint_plan.enable_hint = false;
	8204	+SELECT pg_sleep(1);
	8205	+ pg_sleep
	8206	+----------
	8207	+
	8208	+(1 row)
	8209	+
8204	8210	SELECT reset_stats_and_wait();
8205	8211	reset_stats_and_wait
8206	8212	----------------------

		@@ -8226,6 +8232,12 @@ SELECT relname, seq_scan > 0 as seq_scan, idx_scan > 0 as idx_scan FROM pg_stat_
8226	8232	(1 row)
8227	8233
8228	8234	SET pg_hint_plan.enable_hint = true;
	8235	+SELECT pg_sleep(1);
	8236	+ pg_sleep
	8237	+----------
	8238	+
	8239	+(1 row)
	8240	+
8229	8241	SELECT reset_stats_and_wait();
8230	8242	reset_stats_and_wait
8231	8243	----------------------

		@@ -8274,6 +8286,12 @@ BEGIN
8274	8286	END;
8275	8287	$$ VOLATILE LANGUAGE plpgsql;
8276	8288	SET pg_hint_plan.enable_hint = false;
	8289	+SELECT pg_sleep(1);
	8290	+ pg_sleep
	8291	+----------
	8292	+
	8293	+(1 row)
	8294	+
8277	8295	SELECT reset_stats_and_wait();
8278	8296	reset_stats_and_wait
8279	8297	----------------------

		@@ -8301,6 +8319,12 @@ SELECT relname, seq_scan, idx_scan FROM pg_stat_user_tables WHERE schemaname = '
8301	8319	(2 rows)
8302	8320
8303	8321	SET pg_hint_plan.enable_hint = true;
	8322	+SELECT pg_sleep(1);
	8323	+ pg_sleep
	8324	+----------
	8325	+
	8326	+(1 row)
	8327	+
8304	8328	SELECT reset_stats_and_wait();
8305	8329	reset_stats_and_wait
8306	8330	----------------------

--- a/sql/pg_hint_plan.sql

+++ b/sql/pg_hint_plan.sql

		@@ -971,11 +971,13 @@ END;
971	971	$$ VOLATILE LANGUAGE plpgsql;
972	972	vacuum analyze t1;
973	973	SET pg_hint_plan.enable_hint = false;
	974	+SELECT pg_sleep(1);
974	975	SELECT reset_stats_and_wait();
975	976	SELECT dynsql1(9000);
976	977	SELECT pg_sleep(1);
977	978	SELECT relname, seq_scan > 0 as seq_scan, idx_scan > 0 as idx_scan FROM pg_stat_user_tables WHERE schemaname = 'public' AND relname = 't1';
978	979	SET pg_hint_plan.enable_hint = true;
	980	+SELECT pg_sleep(1);
979	981	SELECT reset_stats_and_wait();
980	982	SELECT dynsql1(9000);
981	983	SELECT pg_sleep(1);

		@@ -996,12 +998,14 @@ BEGIN
996	998	END;
997	999	$$ VOLATILE LANGUAGE plpgsql;
998	1000	SET pg_hint_plan.enable_hint = false;
	1001	+SELECT pg_sleep(1);
999	1002	SELECT reset_stats_and_wait();
1000	1003	SELECT dynsql2(9000);
1001	1004	SELECT pg_sleep(1);
1002	1005	-- one of the index scans happened while planning.
1003	1006	SELECT relname, seq_scan, idx_scan FROM pg_stat_user_tables WHERE schemaname = 'public' AND (relname = 'p1_c1' OR relname = 'p1_c2');
1004	1007	SET pg_hint_plan.enable_hint = true;
	1008	+SELECT pg_sleep(1);
1005	1009	SELECT reset_stats_and_wait();
1006	1010	SELECT dynsql2(9000);
1007	1011	SELECT pg_sleep(1);

Show on old repository browser