Database size will be Huge difference while Restoring

From: Rajmohan Masa <razmohan6(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Database size will be Huge difference while Restoring
Date: 2023-05-05 15:35:02
Message-ID: CAMD-G97NzB66a-0ZQZUQqY8pAkuuk2f9aJT=iihbrQd=3Ye0og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 R*educed
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-05-05 16:22:18 Re: Database size will be Huge difference while Restoring
Previous Message Adrian Klaver 2023-05-05 15:06:29 Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.