Postgres Pro
Downloads
Home   >   mailing lists

Re: Restoration query - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Restoration query
Date
Msg-id CAKFQuwZ2sWccJCVANNQd=DQBw+Qa5ODBuguOFJM69c4b-yo2xA@mail.gmail.com
Whole thread Raw
In response to Restoration query  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: Restoration query
List pgsql-admin
Tree view
On Saturday, July 27, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

After restoring data it shows 
data is 250 GB whereas production database has 352GB of data from where we took the backup.

Why this discrepancy? I have not run full vaccum on production database but it has been cleaned by vaccum and reindexing.


 Table and index bloat isn’t saved in a logical backup.

David J.

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Restoration query
Next
From: Ron Johnson
Date:
Subject: Re: Faster pg_resore with autovacuum off?