MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Fri, 12 Jul 2024 12:15:04 +0530
Message-ID: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
Subject: Regarding tables detach concurrently with run_maintenance_proc()
To: pgsql-general@lists.postgresql.org
Cc: keith.fiske@crunchydata.com
Content-Type: multipart/alternative; boundary="0000000000008dfdf0061d07341c"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoJHVcz1QA4A-YpaLAjpW%2B_gB1D%3DqWShTS_b%2B5Rp7E%3D1Ng%40mail.gmail.com>
Precedence: bulk

--0000000000008dfdf0061d07341c
Content-Type: text/plain; charset="UTF-8"

Hi Respected Team

By default proc() does not detach tables concurrently. How do we implement
tables detach concurrently without blocking running sessions in prod.
why this is very critical to implement for pg_partman.
if this is not available yet on 5.1.0 then when can i expect to get it
if already there then please let me know the implementation of detaching
tables concurrently
Any best way to implement the same please  with out concurrently how do we
ensure data integrity and consistency

Regards
Durga Mahesh

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

<div dir=3D"ltr">Hi Respected Team<div><br></div><div>By default=C2=A0proc(=
) does not detach tables concurrently. How do we implement tables detach co=
ncurrently without blocking running sessions in prod.</div><div>why=C2=A0th=
is is very critical to implement for pg_partman.</div><div>if this is not a=
vailable yet on 5.1.0 then when can i expect to get it=C2=A0</div><div>if a=
lready there then please let me know the implementation=C2=A0of detaching t=
ables concurrently=C2=A0</div><div>Any best way to implement the same pleas=
e=C2=A0 with out concurrently how do we ensure data integrity and consisten=
cy=C2=A0</div><div><br></div><div>Regards</div><div>Durga Mahesh=C2=A0</div=
><div><br></div><div><br></div></div>

--0000000000008dfdf0061d07341c--