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.
Στις 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)
