| From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | keith(dot)fiske(at)crunchydata(dot)com |
| Subject: | Regarding tables detach concurrently with run_maintenance_proc() |
| Date: | 2024-07-12 06:45:04 |
| Message-ID: | CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-in-general |
Hi Respected Team
By default proc() does not detach tables concurrently. How do we implement
tables detach concurrently without blocking running sessions in prod.
why this is very critical to implement for pg_partman.
if this is not available yet on 5.1.0 then when can i expect to get it
if already there then please let me know the implementation of detaching
tables concurrently
Any best way to implement the same please with out concurrently how do we
ensure data integrity and consistency
Regards
Durga Mahesh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pradeep t | 2024-07-12 13:18:33 | Semantic cache capability for Postgresql db |
| Previous Message | Tomas Vondra | 2024-07-11 20:38:56 | Re: page is not marked all-visible but visibility map bit is set in relation "pg_statistic" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durgamahesh Manne | 2024-07-19 12:48:34 | Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
| Previous Message | SUMIT FADALE | 2024-02-18 05:59:18 | Issue while calling the procedure |