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 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 29
pg_hint_plan91-1.0.2.tar.gz 146.88 KB 2014-12-19 16:55 77
pg_hint_plan91-debuginfo-1.0.2-1.el6.x86_64.rpm 120.23 KB 2014-12-19 16:54 13

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 18
pg_hint_plan91-1.1.1.tar.gz 157.47 KB 2014-10-31 17:39 45
pg_hint_plan91-debuginfo-1.1.1-1.el6.x86_64.rpm 120.00 KB 2014-10-31 17:39 12

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 84

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 52
pg_hint_plan92-1.1.3.tar.gz 170.10 KB 2014-12-22 21:26 122
pg_hint_plan92-debuginfo-1.1.3-1.el6.x86_64.rpm 118.66 KB 2014-12-22 21:26 12

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 14
pg_hint_plan92-1.1.2.tar.gz 169.27 KB 2014-12-19 16:57 7
pg_hint_plan92-debuginfo-1.1.2-1.el6.x86_64.rpm 120.23 KB 2014-12-19 16:57 4

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 10
pg_hint_plan92-1.1.1.tar.gz 160.53 KB 2014-10-31 17:36 131
pg_hint_plan92-debuginfo-1.1.1-1.el6.x86_64.rpm 117.59 KB 2014-10-31 17:36 8

Package pg_hint_plan for PostgreSQL 9.3 (recent 3 releases)

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 3
pg_hint_plan93-1.1.4-1.el7.x86_64.rpm 31.09 KB 2017-05-19 15:31 1
pg_hint_plan93-1.1.4.tar.gz 175.91 KB 2017-05-19 15:31 1
pg_hint_plan93-debuginfo-1.1.4-1.el6.x86_64.rpm 121.13 KB 2017-05-19 15:31 0
pg_hint_plan93-debuginfo-1.1.4-1.el7.x86_64.rpm 135.38 KB 2017-05-19 15:31 0

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 64
pg_hint_plan93-1.1.3.tar.gz 170.17 KB 2014-12-22 21:38 192
pg_hint_plan93-debuginfo-1.1.3-1.el6.x86_64.rpm 120.63 KB 2014-12-22 21:38 16

Released at 2014-12-19 16:57
1.1.2

Name Size Hash Date Download count
pg_hint_plan93-1.1.2-1.el6.x86_64.rpm 28.58 KB 2014-12-19 16:57 13
pg_hint_plan93-1.1.2.tar.gz 169.30 KB 2014-12-19 16:57 21
pg_hint_plan93-debuginfo-1.1.2-1.el6.x86_64.rpm 122.11 KB 2014-12-19 16:57 6

Package pg_hint_plan for PostgreSQL 9.4 (recent 3 releases)

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 1
pg_hint_plan94-1.1.4-1.el7.x86_64.rpm 31.15 KB 2017-05-19 15:30 1
pg_hint_plan94-1.1.4.tar.gz 175.79 KB 2017-05-19 15:30 5
pg_hint_plan94-debuginfo-1.1.4-1.el6.x86_64.rpm 127.21 KB 2017-05-19 15:30 1
pg_hint_plan94-debuginfo-1.1.4-1.el7.x86_64.rpm 141.88 KB 2017-05-19 15:30 2

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 2632
pg_hint_plan94-1.1.3-1.el7.x86_64.rpm 30.05 KB 2016-03-25 17:23 35
pg_hint_plan94-1.1.3.tar.gz 173.37 KB 2014-12-22 21:40 1021
pg_hint_plan94-debuginfo-1.1.3-1.el6.x86_64.rpm 126.75 KB 2014-12-22 21:40 435
pg_hint_plan94-debuginfo-1.1.3-1.el7.x86_64.rpm 134.72 KB 2016-03-25 17:23 5

Released at 2014-12-22 11:22
1.1.2

Name Size Hash Date Download count
pg_hint_plan94-1.1.2-1.el6.x86_64.rpm 28.27 KB 2014-12-22 11:23 21
pg_hint_plan94-1.1.2.tar.gz 172.59 KB 2014-12-22 11:23 33
pg_hint_plan94-debuginfo-1.1.2-1.el6.x86_64.rpm 128.19 KB 2014-12-22 11:23 9

Package pg_hint_plan for PostgreSQL 9.5 (recent 3 releases)

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 1
pg_hint_plan95-1.1.4.tar.gz 159.50 KB 2017-05-19 15:28 8
pg_hint_plan95-debuginfo-1.1.4-1.el7.x86_64.rpm 130.11 KB 2017-05-19 15:28 0

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 197
pg_hint_plan95-1.1.3.tar.gz 158.38 KB 2016-03-25 17:29 244
pg_hint_plan95-debuginfo-1.1.3-1.el7.x86_64.rpm 122.42 KB 2016-03-25 17:29 17

Package pg_hint_plan for PostgreSQL 9.6 (recent 3 releases)

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 4
pg_hint_plan96-1.2.1.tar.gz 169.11 KB 2017-05-19 15:33 2
pg_hint_plan96-debuginfo-1.2.1-1.el7.x86_64.rpm 140.15 KB 2017-05-19 14:52 0

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

Released at 2016-11-02 12:46
1.1.3

Name Size Hash Date Download count
pg_hint_plan96-1.1.3-1.el7.x86_64.rpm 30.81 KB 2016-11-02 12:47 123
pg_hint_plan96-1.1.3.tar.gz 160.79 KB 2016-11-02 12:55 86
pg_hint_plan96-debuginfo-1.1.3-1.el7.x86_64.rpm 134.06 KB 2016-11-02 12:47 2