From: | "androxkentaki (dot)" <androxkentaki(at)gmail(dot)com> |
---|---|
To: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>, Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: AW: postgresql long running query |
Date: | 2021-12-08 18:57:22 |
Message-ID: | AM0PR10MB31859B492561952578F7C16CFD6F9@AM0PR10MB3185.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)saffiotti(at)gmail(dot)com>
Sent: Wednesday, December 8, 2021 4:19:33 PM
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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(dot)mladen(at)gmail(dot)com<mailto: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-1217
https://dbwhisperer.wordpress.com
From | Date | Subject | |
---|---|---|---|
Next Message | liam saffioti | 2021-12-08 20:01:53 | Re: AW: postgresql long running query |
Previous Message | liam saffioti | 2021-12-08 15:19:33 | Re: AW: postgresql long running query |