public inbox for [email protected]
help / color / mirror / Atom feedFrom: Durgamahesh Manne <[email protected]>
To: Christoph Berg <[email protected]>
To: Durgamahesh Manne <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
Date: Fri, 19 Jul 2024 20:26:37 +0530
Message-ID: <CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
<CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com>
<[email protected]>
On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <[email protected]> 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
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
In-Reply-To: <CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox