Re: Restoration query

Поиск
Список
Период
Сортировка
От Wasim Devale
Тема Re: Restoration query
Дата
Msg-id CAB5fag6Ro4zea1D1GxOV3zqGd7PBFf=0RwB41M=51mLJgos5hg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Restoration query  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Restoration query
Список pgsql-admin

So the live data is not getting restored? Did not get you. I have checked the same data has been transferred to the tables rows match.

On Sun, 28 Jul, 2024, 9:39 am David G. Johnston, <david.g.johnston@gmail.com> wrote:
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 по дате отправления: