Search Postgresql Archives

Re: DB size difference after restore

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

 





On Wed, Oct 3, 2018 at 6:21 PM Sonam Sharma <sonams1209@xxxxxxxxx> wrote:
Hello Ben,

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

   Backup is taken using pg_dump  and its loaded as psql db name <backup> 


Regards,

Sonam


 

 


On Wed, Oct 3, 2018 at 6:17 PM Benjamin Scherrey <scherrey@xxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux