pg_hint_plan
pg_hint_plan copied to clipboard
ossc-db
Extension adding support for optimizer hints in PostgreSQL
Dear Developers. I am currently using a version of Postgresql 11.2 in CentoOS 7.4 pg_hint_plan is version 1.3.4. Create a function as shown below. ###################################################################### CREATE OR REPLACE FUNCTION test_fnc_2()...
Hi, I'm working to support PostgreSQL v15. Please review the patch. There are only minor changes. Summary of changes are * Update Makefile, README and SPECS * Update the version...
Fix #105 Consider indexes other than btree in restrict_indexes. When SQL was executed with IndexScan hints for non-btree indexes (such as the gin index) agains a partitioned table, PostgreSQL crashed....
Hi! At one of my customers, when SQL was executed with IndexScan hint for non-btree indexes (such as the gin index) against a partitioned table, the backend process crashed and...
I have a query that is joining into an EXISTS clause using a Hash Semi Join. I think it will perform better if it would use a Nested Loop Semi...
(Raising this here from my [StackOverflow](https://stackoverflow.com/questions/77959308).) Basically, I would like to allow us to use pg_hint_plan through Metabase, and the obstacle is that this tool prepends a single-line comment, so...
I have reviewed the documentation and issue list, but I couldn't find how to use the pg_hint_plan extension to force my `group by` SQL query to use hash aggregation. Like...
While using Join and Scan hints in PG v12.16 and pg_hint_plan 1.3.6 , I encountered the problem as follow. Here is a SQl using hints and I expect it join...
We aim to modify each operator on the PG query tree to a specified cardinality, but according to the [documentation](https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hint_table.md), we only found that cardinalities for two-table joins can be...
