Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() - Mailing list pgsql-general

From Christoph Berg
Subject Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
Date
Msg-id Zpp3axAcU7oC5lrB@msg.df7cb.de
Whole thread Raw
In response to Fwd: Regarding tables detach concurrently with run_maintenance_proc()  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Responses Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
List pgsql-general
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 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

You might have more success by filing pg_partman issues at
https://github.com/pgpartman/pg_partman/issues

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

Well you can just run the same commands manually that pg_partman would
run.

Christoph



pgsql-general by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: Query on partitioned table needs memory n_partitions * work_mem
Next
From: Durgamahesh Manne
Date:
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()