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

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 20
pg_hint_plan91-1.1.1.tar.gz 157.47 KB 2014-10-31 17:39 49
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 87

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

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 15
pg_hint_plan92-1.1.2.tar.gz 169.27 KB 2014-12-19 16:57 10
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 11
pg_hint_plan92-1.1.1.tar.gz 160.53 KB 2014-10-31 17:36 132
pg_hint_plan92-debuginfo-1.1.1-1.el6.x86_64.rpm 117.59 KB 2014-10-31 17:36 9

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

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

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 16
pg_hint_plan93-1.1.2.tar.gz 169.30 KB 2014-12-19 16:57 23
pg_hint_plan93-debuginfo-1.1.2-1.el6.x86_64.rpm 122.11 KB 2014-12-19 16:57 8

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 8
pg_hint_plan94-1.1.4-1.el7.x86_64.rpm 31.15 KB 2017-05-19 15:30 10
pg_hint_plan94-1.1.4.tar.gz 175.79 KB 2017-05-19 15:30 19
pg_hint_plan94-debuginfo-1.1.4-1.el6.x86_64.rpm 127.21 KB 2017-05-19 15:30 5
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 2678
pg_hint_plan94-1.1.3-1.el7.x86_64.rpm 30.05 KB 2016-03-25 17:23 48
pg_hint_plan94-1.1.3.tar.gz 173.37 KB 2014-12-22 21:40 1022
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 6

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 23
pg_hint_plan94-1.1.2.tar.gz 172.59 KB 2014-12-22 11:23 37
pg_hint_plan94-debuginfo-1.1.2-1.el6.x86_64.rpm 128.19 KB 2014-12-22 11:23 14

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

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

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 26
pg_hint_plan96-1.2.1.tar.gz 169.11 KB 2017-05-19 15:33 41
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 70
pg_hint_plan96-debuginfo-1.2.0-1.el7.x86_64.rpm 138.61 KB 2017-02-21 09:52 9

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 130
pg_hint_plan96-1.1.3.tar.gz 160.79 KB 2016-11-02 12:55 91
pg_hint_plan96-debuginfo-1.1.3-1.el7.x86_64.rpm 134.06 KB 2016-11-02 12:47 5