ossc-db/pg_hint_plan

Issues

• leading hint + join methods hint cannot totally force the join order.

  #195 opened 6 months ago by ZhengtongYan
  8

• no longer compiles on postgres master

  #197 opened 4 months ago by neiaberau
  2

• Hints do not work on subqueries with DISTINCT

  #187 opened 8 months ago by DontBreakAlex
  1

• Instability of pg_hint_plan.sql test in PG16 + master on a slow box (or when testing with valgrind).

  #161 opened a year ago by svglukhov
  1

• Hinting estimation with duplicate alias names doesn't seem to be supported (?)

  #153 opened 4 months ago by jakubwartakEDB
  1

• Regression with Parallel hints combined with removal of indexes in Index hints

  #164 opened 4 months ago by michaelpq
  11

• Next release of pg_hint_plan with PostgreSQL 17 compatibility

  #190 opened 8 months ago by michaelpq
  26

• Hint IndexScan: more docs and (possibly) check names

  #196 opened 5 months ago by danolivo
  3

• Tolerating preceding single-line comments

  #175 opened 5 months ago by LukeNotable
  3

• Hint to use a Nested Loop Semi Join

  #177 opened 5 months ago by SteveDirschelTR
  1

• Maskout script doesn't work on macOS

  #181 opened 9 months ago by Sanath97
  2

• Allow using table name in hint when there is a single reference for a table

  #154 opened 5 months ago by Akshit97
  1

• Is it possible to inject each operator's cardinality by hint 'Rows' ?

  #167 opened 5 months ago by Wind-Gone
  1

• pg_hint_plan whether support for hints for group by method(hash/sort)?

  #171 opened 5 months ago by ZhiXingHeYiApple
  1

• Does pg_hint_plan support "unnamed_subquery" added as part of PG 16 ?

  #159 opened 5 months ago by dcgadmin
  2

• Scan and Join hints do not work as expected

  #168 opened 5 months ago by lucifer12346
  6

• Row hints doesn't work for TABLE functions

  #157 opened 5 months ago by dgkimura
  3

• Query Errors if pg_hint_plan.enable_hint_table and enable_hint is enabled but hints table does not exist

  #191 opened 8 months ago by samimseih
  15

• Discrepancy in the costs of prepared operators depending on the architecture of the system

  #192 opened 8 months ago by Xen-On-core
  3

• Hint table doesn't seem to have effect on query plans

  #183 opened 8 months ago by avandras
  7

• Cant get normalized text to work with pg plan hint

  #180 opened 8 months ago by fakdaddy75
  2

• Improved repository description?

  #178 opened 9 months ago by justinclift
  9

• make hint relname comparison case insensitive

  #173 opened a year ago by samimseih
  1

• Installation of pg_hint_plan failed for Enterprise DB 14.x

  #169 opened a year ago by somnathkhamaru
  4

• Server crashes on executing explain after invalid hint

  #141 opened 2 years ago by saygoodbyye
  4

• enable_self_join_removal in 17 breaks regression tests that use self-joins

  #166 opened a year ago by samimseih
  1

• Next release for pg_hint_plans

  #128 opened a year ago by michaelpq
  34

• Plugging in a lex/yyac layer into pg_hint_plan

  #132 opened a year ago by michaelpq
  11

• SIGABRT when the parse_messages parameter equals to error.

  #162 opened a year ago by Xen-On-core
  1

• multiple indexes for hints?

  #155 opened a year ago by mahdiyari
  3

• Documentation for branch PG16 is missing

  #152 opened a year ago by michaelpq
  2

• Is there a way to hint the exact list (and order) of columns used by a specific composite index?

  #120 opened a year ago by vladich
  4

• How to use GUC hint for a string

  #118 opened a year ago by mrdrivingduck
  2

• BitmapScan not applied when using a table alias

  #150 opened a year ago by MatteoSp
  4

• When use JDBC's prepared Statement, HINT not work in the middle of the process.

  #145 opened a year ago by kfuru
  9

• Crash of pg_hint_plan with Postgres 16~ with join paths

  #139 opened a year ago by michaelpq
  5

• pg_hint_plan and plugin_debugger don't work together

  #116 opened a year ago by phlaluna
  7

• Specify build and probe tables to hash join possible?

  #146 opened a year ago by Asoke26
  2

• rows hint does not work as expected

  #127 opened a year ago by nikulinas
  1

• Doesn't work unless the execution order is serial

  #140 opened a year ago by come25136
  9

• Error reporting and non-existent indexes

  #126 opened a year ago by Gurmokh
  2

• Why don't set GUC variables manually?

  #137 opened a year ago by danolivo
  1

• Supplying IndexScan hint with unavailable index gives unexpected results.

  #136 opened a year ago by samimseih
  11

• Where are the files for the pg_hint_plan rhel7 release kept?

  #143 opened a year ago by jjune235
  5

• pg_hint_plan-{1.4.1,1.5.0} fail to compile

  #134 opened 2 years ago by patricklauer
  1

• cannot build against postgres master branch

  #122 opened 2 years ago by neiaberau
  1

• Should the HTML documentation be dropped?

  #123 opened 2 years ago by michaelpq
  12

• aws ec2 make fail

  #124 opened 2 years ago by zouchengli
  1

• Planned release for the 25th of January

  #117 opened 2 years ago by michaelpq
  10

• Question about Hint

  #114 opened 2 years ago by Hap-Hugh
  0