pg_hint_plan
pg_hint_plan copied to clipboard
ossc-db
Extension adding support for optimizer hints in PostgreSQL
We have an issues with prepared statements that use arrays as arguments. In this case pg_hint_plan don't pass preceding sql check. Example: ``` prepare test_query(numeric[]) as /*+ MergeJoin(t1 t2) */...
We have an issues with segfault on pg_hint_plan for PG13. We don't have stable case to reproduce theses issues (issue is floating) but it is critical for us because database...
Pull request for synchronization with actual postgresql core code of set_rel_pathlist and dependent functions.
Hello! I'm trying to force specific execution plan (very simple really), but postgre+pg_hint_plan v13 still using shitty plans. Can you suggest any hint combination to force nested loop join exactly...
PostgreSQL verison: 12.3 pg_hint_plan version: REL12_1_3_7 I'm going to build the PostgreSQL project from source code,And I put the `pg_hint_plan` in the contrib folder before building. Then I got two...
Hello all, I am using the TPC-H Benchmark and I am trying to specify a query plan for the query template number 3. More specifically, the query with the hints...
The current release of pg_hint_plan is 1.3.7 that supports up to PostgreSQL 13. I see a couple of new commits 2 weeks ago that update the version to 1.4 with...
PostgreSQL: 10.6 pg_hint_plan: 1.3.1 When I use indexscan(a a.index_name), an error occurs in the database： 2021-11-02 17:38:46.079 CST,,,3954,,61810386.f72,3,,2021-11-02 17:23:18 CST,,0,LOG,00000,"received fast shutdown request",,,,,,,,,"" 2021-11-02 17:38:46.083 CST,,,3954,,61810386.f72,4,,2021-11-02 17:23:18 CST,,0,LOG,00000,"aborting any active...
I have turned `geqo` off and increased `from_collapse_limit` and `join_collapse_limit` to appropriate values. I am attempting to plan the following: ``` /*+ HashJoin(ct t chn cn ci mc rt) HashJoin(t...
Hi, I am using 1.3.7 version downloaded from releases for PostgreSQL 13.1. I also set the parameters `join_collapse_limit=25; from_collapse_limit=25; geqo_threshold = 25; work_mem = "2000MB";` When I run explain of...
