Download List

Project Description

PostgreSQL executes queries using cost-based optimizer, and sometimes fails to choose most optimized execution plan or some types of queries. In such cases, pg_hint_plan helps users to guide the planner to choose the plans they want by putting some nstructions - call them hints - in the comments prefixed to the SQL statement body. No need to rewrite statement tself nor change some GUC parameters elsewhere.

System Requirements

Operating System: BSD
PostgreSQL 9.1, 9.2

Download Package list

Package pg_hint_plan for PostgreSQL 10 (recent 3 releases)

Released at 2017-10-10 12:52
1.3.0

Name Size Hash Date Download count
pg_hint_plan10-1.3.0-1.el7.x86_64.rpm 31.37 KB 2017-10-10 12:53 45
pg_hint_plan10-debuginfo-1.3.0-1.el7.x86_64.rpm 142.34 KB 2017-10-10 12:53 10

Package pg_hint_plan for PostgreSQL 9.1 (recent 3 releases)

Released at 2014-12-19 16:35
1.0.2

Name Size Hash Date Download count
pg_hint_plan91-1.0.2-1.el6.x86_64.rpm 25.93 KB 2014-12-19 16:54 40
pg_hint_plan91-1.0.2.tar.gz 146.88 KB 2014-12-19 16:55 98
pg_hint_plan91-debuginfo-1.0.2-1.el6.x86_64.rpm 120.23 KB 2014-12-19 16:54 17

Released at 2014-10-31 17:39
1.1.1

Name Size Hash Date Download count
pg_hint_plan91-1.1.1-1.el6.x86_64.rpm 25.68 KB 2014-10-31 17:39 21
pg_hint_plan91-1.1.1.tar.gz 157.47 KB 2014-10-31 17:39 53
pg_hint_plan91-debuginfo-1.1.1-1.el6.x86_64.rpm 120.00 KB 2014-10-31 17:39 13

Released at 2014-03-27 12:31
1.1.0 for postgresql9.1.x

Name Size Hash Date Download count
pg_hint_plan110.tar.gz 935.50 KB 2014-03-27 12:33 88

Package pg_hint_plan for PostgreSQL 9.2 (recent 3 releases)

Released at 2014-12-22 21:25
1.1.3

Name Size Hash Date Download count
pg_hint_plan92-1.1.3-1.el6.x86_64.rpm 28.75 KB 2014-12-22 21:26 76
pg_hint_plan92-1.1.3.tar.gz 170.10 KB 2014-12-22 21:26 160
pg_hint_plan92-debuginfo-1.1.3-1.el6.x86_64.rpm 118.66 KB 2014-12-22 21:26 14

Released at 2014-12-19 16:56
1.1.2

Name Size Hash Date Download count
pg_hint_plan92-1.1.2-1.el6.x86_64.rpm 28.60 KB 2014-12-19 16:57 18
pg_hint_plan92-1.1.2.tar.gz 169.27 KB 2014-12-19 16:57 11
pg_hint_plan92-debuginfo-1.1.2-1.el6.x86_64.rpm 120.23 KB 2014-12-19 16:57 6

Released at 2014-10-31 17:33
1.1.1

Name Size Hash Date Download count
pg_hint_plan92-1.1.1-1.el6.x86_64.rpm 26.38 KB 2014-10-31 17:36 12
pg_hint_plan92-1.1.1.tar.gz 160.53 KB 2014-10-31 17:36 133
pg_hint_plan92-debuginfo-1.1.1-1.el6.x86_64.rpm 117.59 KB 2014-10-31 17:36 10

Package pg_hint_plan for PostgreSQL 9.3 (recent 3 releases)

Released at 2017-07-27 19:32
1.1.5

Name Size Hash Date Download count
pg_hint_plan93-1.1.5-1.el7.x86_64.rpm 31.71 KB 2017-07-27 19:32 14
pg_hint_plan93-1.1.5.tar.gz 192.44 KB 2017-07-27 19:32 13
pg_hint_plan93-debuginfo-1.1.5-1.el7.x86_64.rpm 137.53 KB 2017-07-27 19:32 1

Released at 2017-05-19 14:28
1.1.4

Name Size Hash Date Download count
pg_hint_plan93-1.1.4-1.el6.x86_64.rpm 28.62 KB 2017-05-19 15:31 21
pg_hint_plan93-1.1.4-1.el7.x86_64.rpm 31.09 KB 2017-05-19 15:31 7
pg_hint_plan93-1.1.4.tar.gz 175.91 KB 2017-05-19 15:31 19
pg_hint_plan93-debuginfo-1.1.4-1.el6.x86_64.rpm 121.13 KB 2017-05-19 15:31 2
pg_hint_plan93-debuginfo-1.1.4-1.el7.x86_64.rpm 135.38 KB 2017-05-19 15:31 3

Released at 2014-12-22 21:38
1.1.3

Name Size Hash Date Download count
pg_hint_plan93-1.1.3-1.el6.x86_64.rpm 28.76 KB 2014-12-22 21:38 68
pg_hint_plan93-1.1.3.tar.gz 170.17 KB 2014-12-22 21:38 197
pg_hint_plan93-debuginfo-1.1.3-1.el6.x86_64.rpm 120.63 KB 2014-12-22 21:38 20

Package pg_hint_plan for PostgreSQL 9.4 (recent 3 releases)

Released at 2017-07-27 19:31
1.1.5

Name Size Hash Date Download count
pg_hint_plan94-1.1.5-1.el7.x86_64.rpm 31.72 KB 2017-07-27 19:31 19
pg_hint_plan94-1.1.5.tar.gz 191.04 KB 2017-07-27 19:31 30
pg_hint_plan94-debuginfo-1.1.5-1.el7.x86_64.rpm 143.78 KB 2017-07-27 19:31 1

Released at 2017-05-19 15:30
1.1.4

Name Size Hash Date Download count
pg_hint_plan94-1.1.4-1.el6.x86_64.rpm 28.66 KB 2017-05-19 15:30 12
pg_hint_plan94-1.1.4-1.el7.x86_64.rpm 31.15 KB 2017-05-19 15:30 14
pg_hint_plan94-1.1.4.tar.gz 175.79 KB 2017-05-19 15:30 28
pg_hint_plan94-debuginfo-1.1.4-1.el6.x86_64.rpm 127.21 KB 2017-05-19 15:30 6
pg_hint_plan94-debuginfo-1.1.4-1.el7.x86_64.rpm 141.88 KB 2017-05-19 15:30 6

Released at 2014-12-22 21:39
1.1.3

Name Size Hash Date Download count
pg_hint_plan94-1.1.3-1.el6.x86_64.rpm 28.46 KB 2014-12-22 21:40 2726
pg_hint_plan94-1.1.3-1.el7.x86_64.rpm 30.05 KB 2016-03-25 17:23 54
pg_hint_plan94-1.1.3.tar.gz 173.37 KB 2014-12-22 21:40 1028
pg_hint_plan94-debuginfo-1.1.3-1.el6.x86_64.rpm 126.75 KB 2014-12-22 21:40 442
pg_hint_plan94-debuginfo-1.1.3-1.el7.x86_64.rpm 134.72 KB 2016-03-25 17:23 7

Package pg_hint_plan for PostgreSQL 9.5 (recent 3 releases)

Released at 2017-07-27 19:30
1.1.5

Name Size Hash Date Download count
pg_hint_plan95-1.1.5-1.el7.x86_64.rpm 31.15 KB 2017-07-27 19:30 27
pg_hint_plan95-1.1.5.tar.gz 175.12 KB 2017-07-27 19:30 43
pg_hint_plan95-debuginfo-1.1.5-1.el7.x86_64.rpm 130.41 KB 2017-07-27 19:30 5

Released at 2017-05-19 15:26
1.1.4

Name Size Hash Date Download count
pg_hint_plan95-1.1.4-1.el7.x86_64.rpm 30.90 KB 2017-05-19 15:28 18
pg_hint_plan95-1.1.4.tar.gz 159.50 KB 2017-05-19 15:28 22
pg_hint_plan95-debuginfo-1.1.4-1.el7.x86_64.rpm 130.11 KB 2017-05-19 15:28 5

Released at 2016-03-25 17:29
1.1.3

Name Size Hash Date Download count
pg_hint_plan95-1.1.3-1.el7.x86_64.rpm 29.98 KB 2016-03-25 17:29 211
pg_hint_plan95-1.1.3.tar.gz 158.38 KB 2016-03-25 17:29 254
pg_hint_plan95-debuginfo-1.1.3-1.el7.x86_64.rpm 122.42 KB 2016-03-25 17:29 22

Package pg_hint_plan for PostgreSQL 9.6 (recent 3 releases)

Released at 2017-07-27 19:26
1.2.2

Name Size Hash Date Download count
pg_hint_plan96-1.2.2-1.el7.x86_64.rpm 32.16 KB 2017-07-27 19:26 125
pg_hint_plan96-1.2.2.tar.gz 184.04 KB 2017-07-27 19:26 152
pg_hint_plan96-debuginfo-1.2.2-1.el7.x86_64.rpm 140.31 KB 2017-07-27 19:26 12

Released at 2017-05-19 14:52
1.2.1

Name Size Hash Date Download count
pg_hint_plan96-1.2.1-1.el7.x86_64.rpm 31.95 KB 2017-05-19 14:52 28
pg_hint_plan96-1.2.1.tar.gz 169.11 KB 2017-05-19 15:33 54
pg_hint_plan96-debuginfo-1.2.1-1.el7.x86_64.rpm 140.15 KB 2017-05-19 14:52 2

Released at 2017-02-21 09:52
1.2.0

Name Size Hash Date Download count
pg_hint_plan96-1.2.0-1.el7.x86_64.rpm 31.65 KB 2017-02-21 09:52 81
pg_hint_plan96-debuginfo-1.2.0-1.el7.x86_64.rpm 138.61 KB 2017-02-21 09:52 11