Re: after restore the size of the database is increased

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: after restore the size of the database is increased
Date: 2019-07-24 16:38:01
Message-ID: 97067566-24a0-0e68-8ecc-7067b8db57a5@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Souvik Bhattacherjee 2019-07-24 16:54:00 Running concurrent txns and measuring the timings in Postgres
Previous Message Adrian Klaver 2019-07-24 16:11:47 Re: Default ordering option