pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg_cron issue
4+ messages / 3 participants
[nested] [flat]
* Pg_cron issue
@ 2024-06-20 13:04 Sathish Reddy <sathishreddy.postgresql@gmail.com>
2024-06-20 16:47 ` Re: Pg_cron issue Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sathish Reddy @ 2024-06-20 13:04 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org, Keith <keith@keithf4.com>
Hi
We have configure partition maintenance from pg_cron but it not ran and
no log from cron.job_run_details.
Help me
Thanks
Sathish Reddy
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron issue
2024-06-20 13:04 Pg_cron issue Sathish Reddy <sathishreddy.postgresql@gmail.com>
@ 2024-06-20 16:47 ` Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
2024-06-20 20:51 ` Re: Pg_cron issue SOzcn <selahattinozcnma@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Achilleas Mantzios @ 2024-06-20 16:47 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Στις 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)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron issue
2024-06-20 13:04 Pg_cron issue Sathish Reddy <sathishreddy.postgresql@gmail.com>
2024-06-20 16:47 ` Re: Pg_cron issue Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
@ 2024-06-20 20:51 ` SOzcn <selahattinozcnma@gmail.com>
2024-06-20 21:00 ` Re: Pg_cron issue SOzcn <selahattinozcnma@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: SOzcn @ 2024-06-20 20:51 UTC (permalink / raw)
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
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.mantzios@cloud.gatewaynet.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)
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron issue
2024-06-20 13:04 Pg_cron issue Sathish Reddy <sathishreddy.postgresql@gmail.com>
2024-06-20 16:47 ` Re: Pg_cron issue Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
2024-06-20 20:51 ` Re: Pg_cron issue SOzcn <selahattinozcnma@gmail.com>
@ 2024-06-20 21:00 ` SOzcn <selahattinozcnma@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: SOzcn @ 2024-06-20 21:00 UTC (permalink / raw)
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
P.S. Check your times on the server and PostgreSQL. You can have a time
difference. Check your PostgreSQL Configuration file too. Have a nice day.
SOzcn <selahattinozcnma@gmail.com>, 20 Haz 2024 Per, 23:51 tarihinde şunu
yazdı:
> 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.mantzios@cloud.gatewaynet.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)
>>
>>
>>
>>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-06-20 21:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-20 13:04 Pg_cron issue Sathish Reddy <sathishreddy.postgresql@gmail.com>
2024-06-20 16:47 ` Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
2024-06-20 20:51 ` SOzcn <selahattinozcnma@gmail.com>
2024-06-20 21:00 ` SOzcn <selahattinozcnma@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox