Postgres Pro
Downloads
Home   >   mailing lists

Re: Restoration query - Mailing list pgsql-admin

From Wasim Devale
Subject Re: Restoration query
Date
Msg-id CAB5fag6Ro4zea1D1GxOV3zqGd7PBFf=0RwB41M=51mLJgos5hg@mail.gmail.com
Whole thread Raw
In response to Re: Restoration query  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Restoration query
List pgsql-admin
Tree view

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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restoration query
Next
From: "David G. Johnston"
Date:
Subject: Re: Restoration query