Re: Maintenance

Поиск
Список
Период
Сортировка
От Wasim Devale
Тема Re: Maintenance
Дата
Msg-id CAB5fag5r6wg+86DaidqGQWek3y3XsJEi5+51jqxsxZbQ9Hf6yg@mail.gmail.com
обсуждение исходный текст
Ответ на Maintenance  (Sunil Jadhav <sunilbjpatil@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Sunil Jadhav
Дата:
Сообщение: Maintenance
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Maintenance