From: | Christoph Berg <myon(at)debian(dot)org> |
---|---|
To: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org |
Subject: | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Date: | 2024-07-19 14:25:47 |
Message-ID: | Zpp3axAcU7oC5lrB@msg.df7cb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-in-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
From | Date | Subject | |
---|---|---|---|
Next Message | Durgamahesh Manne | 2024-07-19 14:56:37 | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Previous Message | Dimitrios Apostolou | 2024-07-19 13:31:34 | Re: Query on partitioned table needs memory n_partitions * work_mem |
From | Date | Subject | |
---|---|---|---|
Next Message | Durgamahesh Manne | 2024-07-19 14:56:37 | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Previous Message | Durgamahesh Manne | 2024-07-19 12:48:34 | Fwd: Regarding tables detach concurrently with run_maintenance_proc() |