Re: DB size difference after restore

From: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
To: Sonam Sharma <sonams1209(at)gmail(dot)com>
Cc: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB size difference after restore
Date: 2018-10-03 12:46:55
Message-ID: CACo3ShiVYXkX+QN6hgO4Ms9o2hYKqQYst7h5jH3T3nMASYWW4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sonam Sharma 2018-10-03 12:51:01 Re: DB size difference after restore
Previous Message Sonam Sharma 2018-10-03 12:42:35 DB size difference after restore