Re: DB size difference after restore - Mailing list pgsql-general

From Sonam Sharma
Subject Re: DB size difference after restore
Date
Msg-id CAM-M3TmTx1a_wvdN6f3YTAXGR4U2h9+qEhSXXpivcG4fpB7UZA@mail.gmail.com
Whole thread Raw
In response to Re: DB size difference after restore  (Benjamin Scherrey <scherrey@proteus-tech.com>)
Responses Re: DB size difference after restore  (Fabio Pardi <f.pardi@portavita.eu>)
Re: DB size difference after restore  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
Hello Ben,

When we do \l+ , it is different than sourcewhen we load backup from target server


Regards,

Sonam


 

 


On Wed, Oct 3, 2018 at 6:17 PM Benjamin Scherrey <scherrey@proteus-tech.com> wrote:
If you're talking about space on drive then you can expect the new one to be smaller generally as it has been straight efficient writes rather than a bunch of updates and deletes which create "holes" in the physical file space.

It helps if you are more detailed as to what you've observed if you want a more specific answer. 

  - - Ben Scherrey 

On Wed, Oct 3, 2018, 7:43 PM Sonam Sharma <sonams1209@gmail.com> wrote:
I have restored the database from backup dump but the size of source and target databases are different. What can be the reason for this ?

Regards,
Sonam

pgsql-general by date:

Previous
From: Benjamin Scherrey
Date:
Subject: Re: DB size difference after restore
Next
From: Fabio Pardi
Date:
Subject: Re: DB size difference after restore