Re: DB size difference after restore

Поиск
Список
Период
Сортировка
От Benjamin Scherrey
Тема Re: DB size difference after restore
Дата
Msg-id CACo3ShiVYXkX+QN6hgO4Ms9o2hYKqQYst7h5jH3T3nMASYWW4Q@mail.gmail.com
обсуждение исходный текст
Ответ на DB size difference after restore  (Sonam Sharma <sonams1209@gmail.com>)
Ответы Re: DB size difference after restore  (Sonam Sharma <sonams1209@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Sonam Sharma
Дата:
Сообщение: DB size difference after restore
Следующее
От: Sonam Sharma
Дата:
Сообщение: Re: DB size difference after restore