Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()

On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <myon(at)debian(dot)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