Re: Restoration query

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Restoration query
Date: 2024-07-28 04:09:17
Message-ID: CAKFQuwaXNS_vvK_RQ9wTpn1ONUycnqHgH8oq2EwAN1gCzut-HA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Saturday, July 27, 2024, Wasim Devale <wasimd60(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wasim Devale 2024-07-28 04:55:48 Re: Restoration query
Previous Message Wasim Devale 2024-07-28 04:04:52 Re: Restoration query