Home > mailing lists

Restoration query - Mailing list pgsql-admin

From	Wasim Devale
Subject	Restoration query
Date	July 27 21:34:03
Msg-id	CAB5fag6YxBbuR3af17tU1y3_E0HwsO0SDcW+pif9LPNQerYayA@mail.gmail.com Whole thread Raw
Responses	Re: Restoration query
List	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

From: Wells Oliver
Date: 27 July, 20:12:49
Subject: Re: Faster pg_resore with autovacuum off?

From: "David G. Johnston"
Date: 27 July, 21:35:39
Subject: Re: Restoration query