2 SET pg_hint_plan.enable TO on;
3 SET pg_hint_plan.debug_print TO on;
4 SET search_path TO public;
7 ---- No. G-2-2 category of GUC parameter and role
12 /*+Set(block_size 16384)*/
13 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
16 /*+Set(archive_mode off)*/
17 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
20 /*+Set(archive_timeout 0)*/
21 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
24 /*+Set(log_connections off)*/
25 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
28 /*+Set(log_min_messages WARNING)*/
29 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
33 GRANT ALL ON SCHEMA s1 TO PUBLIC;
34 GRANT SELECT ON ALL TABLES IN SCHEMA s1 TO normal_user;
36 /*+Set(log_min_messages WARNING)*/
37 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
40 /*+Set(enable_seqscan on)*/
41 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
44 REVOKE SELECT ON ALL TABLES IN SCHEMA s1 FROM normal_user;
45 REVOKE ALL ON SCHEMA s1 FROM PUBLIC;
48 ---- No. G-2-3 conflict set hint
51 SET client_min_messages TO LOG;
53 /*+Set(enable_indexscan on)Set(enable_indexscan off)*/
54 SELECT * FROM s1.t1 WHERE false;
57 /*+Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBUG2)*/
58 SELECT * FROM s1.t1 WHERE false;
61 /*+Set(enable_indexscan on)Set(enable_indexscan o)*/
62 SELECT * FROM s1.t1 WHERE false;
65 /*+Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBU)*/
66 SELECT * FROM s1.t1 WHERE false;