Postgres Pro
Downloads
Home   >   mailing lists

Database size will be Huge difference while Restoring - Mailing list pgsql-general

From Rajmohan Masa
Subject Database size will be Huge difference while Restoring
Date
Msg-id CAMD-G97NzB66a-0ZQZUQqY8pAkuuk2f9aJT=iihbrQd=3Ye0og@mail.gmail.com
Whole thread Raw
Responses Re: Database size will be Huge difference while Restoring  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi Team,
I took Postgres database Backup through Directory format with compression.These are the details
Database Size: 3985 GB
Backup file Size will be 212 GB.

After that I Restored this backup file (212GB), but I'm getting Database size will be 456 GB.

So immediately I checked with Table Bloats,latest statistics and last vacuum status. After that I applied "Vacuum Full Verbose analyze" and " Reindex  " on that Database. Here I achieved Database size will be Reduced from 3985 GB to 2582GB.

After this process,again I took  Backup through Directory format with compression.These are the details
Database Size: 2582 GB
Backup file Size will be 212 GB.

After that I Restored this backup file (212 GB), but I'm getting Database size will be 456 GB.

Here I checked with Object Counts, I'm getting the same count in Both Db's.

why am I unable to get Original Database size/Approximately nearby original DB size in restore location ?



Thanks & Regards,
Rajamohan M.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.
Next
From: Adrian Klaver
Date:
Subject: Re: Database size will be Huge difference while Restoring