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