pg_hint_plan
pg_hint_plan copied to clipboard
ossc-db
Extension adding support for optimizer hints in PostgreSQL
parallel hint behave strangely as following example shows: ``` create table t1(id int,val int); create table t2(id int,val int); create table t3(id int,val int); ``` case 1: no hint ```...
I'm currently trying to use pg_hint_plan for research purposes, and I need a way to insert single-table cardinality estimates of the form: Rows( table1 #1000) I've tried to implement this...
PullRequest "Add Test by GithubActions". Please check GithubActions in my repository. https://github.com/SeinoYuki/pg_hint_plan/actions This test supports CentOS7,UBI8 and UBI9. In the regression test, locale ja_JP is used, but will be changed...
pg13 pg_hint_plan 13.7 case1 parallel not work when only one table: ``` chuhx@postgres=# create table test(id int,val int); CREATE TABLE chuhx@postgres=# explain select * from test; QUERY PLAN -------------------------------------------------------- Seq...
Hi. We have an issues related to the invalid value of plpgsql_recurse_level counter in the PG13 and current master branch (Postgres 14). The issue is that when we catch and...
Case to reproduce: We have an issues with prepared statements that use arrays in arguments. In this case pg_hint_plan don't pass preceding sql check. Is it possible to adds '[',...
We have several cases where we need hints to be anywhere inside query and at the same time we need analysis to understand that hints are not part of string...
We have an issues related to the invalid value of plpgsql_recurse_level counter in the PG13 and current master branch (Postgres 14). The issue appears when we catch and handle any...
We have hints that are used by another extension or hints that are used by an external applications(outside of the database layer). We also have cases when some queries using...