Re: after restore the size of the database is increased

Поиск
Список
Период
Сортировка
От Alexey Bashtanov
Тема Re: after restore the size of the database is increased
Дата
Msg-id 97067566-24a0-0e68-8ecc-7067b8db57a5@imap.cc
обсуждение исходный текст
Ответ на after restore the size of the database is increased  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general

> Hi all,
> this should be trivial, but if I dump and restore the very same
> database the restored one is bigger than the original one.
> I did vacuumed the database foo, then dumped and restored into bar,
> and the latter, even when vacuumed, remains bigger then the original
> one.
> No other activity was running on the cluster.
>

I can also think of toast data rearranged differently after dump-restore,
accidentally in such a way that it's packed into pages more efficiently.

Not that the probability of such a behavior is very high though.

Best regards,
   Alexey



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Default ordering option
Следующее
От: Souvik Bhattacherjee
Дата:
Сообщение: Running concurrent txns and measuring the timings in Postgres