Restoration query

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Restoration query
Date: 2024-07-27 18:34:03
Message-ID: CAB5fag6YxBbuR3af17tU1y3_E0HwsO0SDcW+pif9LPNQerYayA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

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.

Please advise.

Thanks,
Wasim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-07-27 18:35:39 Re: Restoration query
Previous Message Wells Oliver 2024-07-27 17:12:49 Re: Faster pg_resore with autovacuum off?