Restoration query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Restoration query
From: Wasim Devale <wasimd60@xxxxxxxxx>
Date: Sun, 28 Jul 2024 00:04:03 +0530

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

Follow-Ups:
- Re: Restoration query
  - From: David G. Johnston

Prev by Date: Re: Faster pg_resore with autovacuum off?
Next by Date: Re: Restoration query
Previous by thread: Faster pg_resore with autovacuum off?
Next by thread: Re: Restoration query
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux