Regarding rum_maintenance_proc() with concurrently - Mailing list pgsql-admin

From Durgamahesh Manne
Subject Regarding rum_maintenance_proc() with concurrently
Date
Msg-id CAJCZkoJLe4=9UUu0Rsv2sa1W2Nj+RPMBiNTAJROq1esFNyw2NA@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi
With pg_partman we know the use case .By default run_maintenance_proc() does not detach tables concurrently. How do we implement tables detach concurrently without blocking other sessions

We need to detach child tables with concurrently option to ensure that detach to be happened without skipping when running queries on parent table based on the retention policy as here some of the queries not using date column which in turn to scan all available child tables

There would be no problem while detaching tables if queries using date column

* Is there any option to detach tables concurrently with the mentioned proc in case of queries not using date column ?

I hope you guys can understand an issue which we are facing on pg_partman

Regards,
Durga Mahesh

pgsql-admin by date:

Previous
From: Thomas Simpson
Date:
Subject: Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)
Next
From: Somnath Som
Date:
Subject: Data Issue