Hi,
Sorry for late reply, I think you will having some script that drops and
creates daily partitions etc, command for disabling/removing any constraint
can be placed before these statements so that when the script runs it does
the needful.
Regards,
Muhammad Ikram
Bitnine global
On Tue, Jul 2,
On Tue, 2 Jul, 2024, 12:43 pm Muhammad Ikram, wrote:
> Hi Yudhi,
>
> I think disabling foreign keys before maintenance will help.
>
> --
> Muhammad Ikram
>
Do you mean to say call the parent table first for maintenance followed by
child, and remove all the foreign key first which are pointing to
Hi Yudhi,
I think disabling foreign keys before maintenance will help.
Regards,
Muhammad Ikram
Bitnine global
On Tue, Jul 2, 2024 at 11:41 AM yudhi s wrote:
> Hello All,
> In postgres we are seeing issues during automatic partition maintenance
> using pg_partman extension. So basically it auto
Hello All,
In postgres we are seeing issues during automatic partition maintenance
using pg_partman extension. So basically it automatically creates one new
partition and drops one historical partition each day based on the set
retention period in part_config. We just call it like
partman.run_maint
