Re: Restoration query - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Restoration query
Date
Msg-id CAKFQuwaXNS_vvK_RQ9wTpn1ONUycnqHgH8oq2EwAN1gCzut-HA@mail.gmail.com
Whole thread Raw
In response to Re: Restoration query  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: Restoration query
List 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 by date:

Previous
From: Wasim Devale
Date:
Subject: Re: Restoration query
Next
From: Wasim Devale
Date:
Subject: Re: Restoration query