Re: AW: postgresql long running query

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Wed, 8 Dec 2021 09:11:38 -0500



    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