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 15
pg_hint_plan10-debuginfo-1.3.0-1.el7.x86_64.rpm 142.34 KB 2017-10-10 12:53 4

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 38
pg_hint_plan91-1.0.2.tar.gz 146.88 KB 2014-12-19 16:55 95
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 69
pg_hint_plan92-1.1.3.tar.gz 170.10 KB 2014-12-22 21:26 148
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 9
pg_hint_plan93-1.1.5.tar.gz 192.44 KB 2017-07-27 19:32 11
pg_hint_plan93-debuginfo-1.1.5-1.el7.x86_64.rpm 137.53 KB 2017-07-27 19:32 0

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 16
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 67
pg_hint_plan93-1.1.3.tar.gz 170.17 KB 2014-12-22 21:38 195
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 12
pg_hint_plan94-1.1.5.tar.gz 191.04 KB 2017-07-27 19:31 21
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 11
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 27
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 2714
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 1027
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 16
pg_hint_plan95-1.1.5.tar.gz 175.12 KB 2017-07-27 19:30 36
pg_hint_plan95-debuginfo-1.1.5-1.el7.x86_64.rpm 130.41 KB 2017-07-27 19:30 3

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 21
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 207
pg_hint_plan95-1.1.3.tar.gz 158.38 KB 2016-03-25 17:29 252
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 74
pg_hint_plan96-1.2.2.tar.gz 184.04 KB 2017-07-27 19:26 105
pg_hint_plan96-debuginfo-1.2.2-1.el7.x86_64.rpm 140.31 KB 2017-07-27 19:26 9

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 50
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 78
pg_hint_plan96-debuginfo-1.2.0-1.el7.x86_64.rpm 138.61 KB 2017-02-21 09:52 11