From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org |
Subject: | Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Date: | 2024-07-19 12:48:34 |
Message-ID: | CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-in-general |
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
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
Do we have any other alternative rather than using pg_partman()?
your response is valuable
Regards,
Durga Mahesh
From | Date | Subject | |
---|---|---|---|
Next Message | KK CHN | 2024-07-19 13:08:51 | Re: PgbackRest and EDB Query |
Previous Message | Laurenz Albe | 2024-07-19 07:22:10 | Re: Planet Postgres and the curse of AI |
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2024-07-19 14:25:47 | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Previous Message | Durgamahesh Manne | 2024-07-12 06:45:04 | Regarding tables detach concurrently with run_maintenance_proc() |