Re: Maintenance - Mailing list pgsql-admin

From Wasim Devale
Subject Re: Maintenance
Date
Msg-id CAB5fag5r6wg+86DaidqGQWek3y3XsJEi5+51jqxsxZbQ9Hf6yg@mail.gmail.com
Whole thread Raw
In response to Maintenance  (Sunil Jadhav <sunilbjpatil@gmail.com>)
List 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@gmail.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 

pgsql-admin by date:

Previous
From: Sunil Jadhav
Date:
Subject: Maintenance
Next
From: Thomas Kellerer
Date:
Subject: Re: Maintenance