pg_hint_plan
pg_hint_plan copied to clipboard
ossc-db
Extension adding support for optimizer hints in PostgreSQL
A user has reported a regression in the latest release series regarding subject, related to commit 684986acc3b3156aaf22c1571cd44dd34059a346 (applies to all stable branches). Imagine two simple tables: ``` CREATE TABLE bookings...
Instability of pg_hint_plan.sql test in PG16 + master on a slow box (or when testing with valgrind).
Hi, There is an instability of pg_hint_plan.sql test in PG16 + master on a slow box (or when testing with valgrind). How to repeat: run make installcheck with the postgres...
It doesn't seem possible to assign a row hint on table functions. For example: ```sql CREATE FUNCTION my_table_func(int) RETURNS TABLE(f1 int, f2 text) AS $$ SELECT $1, CAST($1 AS text)...
Does pg_hint_plan support "unnamed_subquery" added as part of PG 16 for sub-query without aliases for any hints on it like Rows?
While using hints which require table name/alias name like INDEXSCAN, if we have a query without any alias then we can use the table name in the hint, but if...
Hi, I'm trying to use pg_hint_plan to hint estimations using the Rows() hint in case of duplicate rel aliases? E.g. given the sample like this: ``` DROP TABLE t1, t2,...
I tested Q19a query of JOB benchmark in the latest PG17beta1 version. I found the following problems which indicate that hints cannot totally force the decisions of optimizer and optimizer...
if a user enables ```enable_hint_table``` and ```enable_hint``` but the ```hint_plan.hints``` does not exist, it will lead to query failure. I don't think this should result in an error, but should...
Hi all, I have that on my tablets for some time. Let's do a new release of this module at the same time as PostgreSQL 17. I have on my...
I could not get some hint to work a bigger query and narrowed the issue to this pattern: ```SQL CREATE TABLE t1 (id int PRIMARY KEY, val int); CREATE TABLE...
