From: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com> |
---|---|
To: | "androxkentaki (dot)" <androxkentaki(at)gmail(dot)com> |
Cc: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: AW: postgresql long running query |
Date: | 2021-12-08 20:01:53 |
Message-ID: | CAGHjuaaTpDhE=09eJ9hOmeqQ4RhS_NWQAD2tJwS4YqMWR0DjHw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have a psql script that runs every 15 minutes in cron.
Thanks,
Liam
androxkentaki . <androxkentaki(at)gmail(dot)com>, 8 Ara 2021 Çar, 21:57 tarihinde
şunu yazdı:
> 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>, 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | androxkentaki | 2021-12-08 20:17:24 | Re: AW: postgresql long running query |
Previous Message | androxkentaki . | 2021-12-08 18:57:22 | Re: AW: postgresql long running query |