Re: AW: postgresql long running query
| От | liam saffioti |
|---|---|
| Тема | Re: AW: postgresql long running query |
| Дата | |
| Msg-id | CAGHjuaam+KTuvGXXF0p=vK2-nNCgBmjbnuMHcf9GrA4oUR_O9w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: AW: postgresql long running query (Mladen Gogala <gogala.mladen@gmail.com>) |
| Ответы |
Re: AW: postgresql long running query
Re: AW: postgresql long running query |
| Список | pgsql-admin |
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.mladen@gmail.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-1217 https://dbwhisperer.wordpress.com
В списке pgsql-admin по дате отправления: