| From: | SOzcn <selahattinozcnma(at)gmail(dot)com> |
|---|---|
| To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg_cron issue |
| Date: | 2024-06-20 20:51:50 |
| Message-ID: | CAJyV5AauvC2n5Vez8exqDyE9Et-8b1pgD8LhNYjuHLLd=0a1fg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
Why do you need pg_cron for partition? You can use pg_partman for
partitioning. Do you mean index and vacuum maintenance steps?
If you doing index maintenance, all of them have it anyway. The
partitioning indexes belong to main table mostly, if you created indexes
only partitioning tables I would advise you to drop them and make it with
main table.
Can you give details? Have a nice day.
Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>, 20 Haz 2024 Per,
19:47 tarihinde şunu yazdı:
> Στις 20/6/24 16:04, ο/η Sathish Reddy έγραψε:
> > Hi
> > We have configure partition maintenance from pg_cron but it not ran
> > and no log from cron.job_run_details.
> >
> >
> check your kern.log for any processes killed by OOM killer
> > Help me
> >
> > Thanks
> > Sathish Reddy
>
> --
> Achilleas Mantzios
> IT DEV - HEAD
> IT DEPT
> Dynacom Tankers Mgmt (as agents only)
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SOzcn | 2024-06-20 21:00:17 | Re: Pg_cron issue |
| Previous Message | Achilleas Mantzios | 2024-06-20 16:47:39 | Re: Pg_cron issue |