| From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
|---|---|
| To: | Sunil Jadhav <sunilbjpatil(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Maintenance |
| Date: | 2024-05-08 09:31:32 |
| Message-ID: | CAB5fag5r6wg+86DaidqGQWek3y3XsJEi5+51jqxsxZbQ9Hf6yg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi run vacuum only not full vaccum. And create a table using this existing
table, partition it and then rename it to original table.
On Wed, 8 May, 2024, 2:48 pm Sunil Jadhav, <sunilbjpatil(at)gmail(dot)com> wrote:
> Hello team,
>
> We have a 12TB db and one table having around 7 TB data , is there any
> option we can removed the dead tuple and size also increase for that
> partition without downtime .
> Vaccum full we can't do because of
> exclusive lock in tables during processing.
>
> We have critical application so don't get the downtown so how to achieve
> this please let us know
>
>
> Thank you
> Sunil
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2024-05-08 12:02:45 | Re: Maintenance |
| Previous Message | Sunil Jadhav | 2024-05-08 09:17:46 | Maintenance |