On 12/8/21 06:13, Dischner, Anton wrote:
>
> Do optimizer hints in PG exists?
>
> Obviously not: https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion
>
Yes, they do exist: http://pghintplan.osdn.jp/pg_hint_plan.html
Packages can be downloaded here:
https://osdn.net/projects/pghintplan/releases/73862
There is no package for version 14, you will have to build it from the
source:
https://github.com/ossc-db/pg_hint_plan
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com