Re: AW: postgresql long running query

Hi everyone,

Thank you for your help. But my query is not always slow. It works fast
under normal conditions, but in a way that I don't understand it works very
slow at some times.
I think there may be a different reason why a query that takes 800ms, in
general, takes 18 minutes at a time.

Thanks a lot
Liam

Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, 8 Ara 2021 Çar, 17:11 tarihinde
şunu yazdı:

> 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-1217https://dbwhisperer.wordpress.com
>
>