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

2024-07-21 Thread Muhammad Imtiaz
Hi , You can consider the pg_pathman extension. *Muhammad Imtiaz* *PostgreSQL Technical Support Lead * */ Pakistan R&D* *Mobile: +923345072521* *Email: imtia...@bitnine.net * On Fri, Jul 19, 2024 at 7:55 PM Durgamahesh Manne wrote: > > > On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg wrote

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

2024-07-19 Thread Durgamahesh Manne
On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg 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 w

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

2024-07-19 Thread Christoph Berg
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

Fwd: Regarding tables detach concurrently with run_maintenance_proc()

2024-07-19 Thread Durgamahesh Manne
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 rete