Re: AW: postgresql long running query

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: AW: postgresql long running query
Date: 2021-12-08 14:11:38
Message-ID: f8d3af50-eabe-4b85-e1ce-ac63d1c8fe92@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message liam saffioti 2021-12-08 15:19:33 Re: AW: postgresql long running query
Previous Message hubert depesz lubaczewski 2021-12-08 12:23:16 Re: PostgreSQL(v9.6.5) not releasing old/inactive IDLE connections