Re: Question on pg_cron

2024-06-08 Thread sud
On Sat, Jun 8, 2024 at 10:05 PM yudhi s wrote: > > > On Sat, 8 Jun, 2024, 9:53 pm Ron Johnson, wrote: > >> On Sat, Jun 8, 2024 at 5:31 AM yudhi s >> wrote: >> >>> Hello All, >>> >>> We have around 10 different partition tables for which the partition >>> maintenance is done using pg_partman ext

Re: Question on pg_cron

2024-06-08 Thread yudhi s
On Sat, 8 Jun, 2024, 9:53 pm Ron Johnson, wrote: > On Sat, Jun 8, 2024 at 5:31 AM yudhi s > wrote: > >> Hello All, >> >> We have around 10 different partition tables for which the partition >> maintenance is done using pg_partman extension. These tables have foreign >> key dependency between the

Re: Question on pg_cron

2024-06-08 Thread Ron Johnson
On Sat, Jun 8, 2024 at 5:31 AM yudhi s wrote: > Hello All, > > We have around 10 different partition tables for which the partition > maintenance is done using pg_partman extension. These tables have foreign > key dependency between them. We just called partman.run_maintanance_proc() > through p