MIME-Version: 1.0
References: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
 <CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com> <Zpp3axAcU7oC5lrB@msg.df7cb.de>
In-Reply-To: <Zpp3axAcU7oC5lrB@msg.df7cb.de>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Fri, 19 Jul 2024 20:26:37 +0530
Message-ID: <CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com>
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
To: Christoph Berg <myon@debian.org>, Durgamahesh Manne <maheshpostgres9@gmail.com>, 
	pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cea29d061d9ae257"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoLoubpxgiuz2d5n%2BCkCdjc44FiE_zMMchghxGXFjrJqMA%40mail.gmail.com>
Precedence: bulk

--000000000000cea29d061d9ae257
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Jul 19, 2024 at 7:55=E2=80=AFPM Christoph Berg <myon@debian.org> wr=
ote:

> 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

--000000000000cea29d061d9ae257
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 19, 2024 at 7:55=E2=80=AF=
PM Christoph Berg &lt;<a href=3D"mailto:myon@debian.org">myon@debian.org</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Re:=
 Durgamahesh Manne<br>
&gt; with pg_partman By default proc() does not detach tables concurrently.=
 How<br>
&gt; do we implement tables detach concurrently without blocking other sess=
ions<br>
&gt; Here queries not using date column to detach tables with<br>
&gt; run_maintenance_proc() which is not using concurrently=C2=A0 based on =
the<br>
&gt; retention policy which leads to scan all available child tables hence =
need<br>
&gt; to trigger this proc with concurrently option to avoid blocking other =
child<br>
&gt; tables beyond rentention policy while running statements on them<br>
<br>
You might have more success by filing pg_partman issues at<br>
<a href=3D"https://github.com/pgpartman/pg_partman/issues" rel=3D"noreferre=
r" target=3D"_blank">https://github.com/pgpartman/pg_partman/issues</a><br>
<br>
&gt; Do we have any other alternative rather than using pg_partman()?<br>
<br>
Well you can just run the same commands manually that pg_partman would<br>
run.<br>
<br>
Christoph<br></blockquote><div><br></div><div>Hi=C2=A0</div><div>You might =
have more success by filing pg_partman issues at<br><a href=3D"https://gith=
ub.com/pgpartman/pg_partman/issues" rel=3D"noreferrer" target=3D"_blank">ht=
tps://github.com/pgpartman/pg_partman/issues</a>=C2=A0 =C2=A0 =C2=A0&gt;&gt=
;&gt; okay<br>=C2=A0My intention is to have any other extension=C2=A0other =
than pg_partman to manage table partitions manually</div><div><br></div><di=
v>Regards</div><div>Durga Mahesh</div></div></div>

--000000000000cea29d061d9ae257--