On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <m...@debian.org> wrote:
> Re: Durgamahesh Manne > > with pg_partman By default proc() does not detach tables concurrently. > How > > do we implement tables detach concurrently without blocking other > sessions > > Here queries not using date column to detach tables with > > run_maintenance_proc() which is not using concurrently based on the > > retention policy which leads to scan all available child tables hence > need > > to trigger this proc with concurrently option to avoid blocking other > child > > tables beyond rentention policy while running statements on them > > You might have more success by filing pg_partman issues at > https://github.com/pgpartman/pg_partman/issues > > > Do we have any other alternative rather than using pg_partman()? > > Well you can just run the same commands manually that pg_partman would > run. > > Christoph > Hi You might have more success by filing pg_partman issues at https://github.com/pgpartman/pg_partman/issues >>> okay My intention is to have any other extension other than pg_partman to manage table partitions manually Regards Durga Mahesh
