Re: AW: postgresql long running query

Поиск
Список
Период
Сортировка
От androxkentaki .
Тема Re: AW: postgresql long running query
Дата
Msg-id AM0PR10MB31859B492561952578F7C16CFD6F9@AM0PR10MB3185.EURPRD10.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: AW: postgresql long running query  (liam saffioti <liam.saffiotti@gmail.com>)
Ответы Re: AW: postgresql long running query  (liam saffioti <liam.saffiotti@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Can you tell us how do you run query at night?
IS it via Odbc? Or direct by pgsql script in cron?

Pozdrawiam
Andrzej Gerasimuk
From: liam saffioti <liam.saffiotti@gmail.com>
Sent: Wednesday, December 8, 2021 4:19:33 PM
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: 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.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 по дате отправления:

Предыдущее
От: liam saffioti
Дата:
Сообщение: Re: AW: postgresql long running query
Следующее
От: liam saffioti
Дата:
Сообщение: Re: AW: postgresql long running query