Re: Restoration query

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Restoration query
Дата
Msg-id CAKFQuwaXNS_vvK_RQ9wTpn1ONUycnqHgH8oq2EwAN1gCzut-HA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Restoration query  (Wasim Devale <wasimd60@gmail.com>)
Ответы Re: Restoration query
Список pgsql-admin
On Saturday, July 27, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

It's a .dmp custom format dump from Azure pipeline and it is of 250GB only.

I ran reindexing and vacuum but not full vacuum. So there cannot be an index or table bloating.


If you didn’t run vacuum full there is most definitely table bloating.  Which, in this definition, is any space taken up in the data files that isn’t storing live data.

David J. 

В списке pgsql-admin по дате отправления: