MIME-Version: 1.0
References: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
In-Reply-To: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Fri, 19 Jul 2024 18:18:34 +0530
Message-ID: <CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com>
Subject: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ed4085061d9918fd"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z%2B%3Dy-A%40mail.gmail.com>
Precedence: bulk

--000000000000ed4085061d9918fd
Content-Type: text/plain; charset="UTF-8"

Hi Respected Team

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

Do we have any other alternative rather than using pg_partman()?

your response is valuable

Regards,
Durga Mahesh

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

<div dir=3D"ltr"><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"g=
mail_attr"><br></div><div dir=3D"ltr">Hi Respected Team<div><br></div><div>=
with pg_partman By default=C2=A0proc() does not detach tables concurrently.=
 How do we implement tables detach concurrently without blocking other sess=
ions=C2=A0</div><div>Here queries not using date column to detach tables wi=
th run_maintenance_proc() which is not using concurrently=C2=A0 based on th=
e retention policy which leads to scan all available child tables hence nee=
d to trigger this proc with concurrently option to avoid blocking other chi=
ld tables beyond rentention policy while running statements on them</div><d=
iv><br></div><div>Do we have any other alternative rather than using pg_par=
tman()?</div><div><br></div><div>your response is valuable=C2=A0</div><div>=
<br></div><div>Regards,</div><div>Durga Mahesh</div><div><br></div></div>
</div></div>

--000000000000ed4085061d9918fd--