On Wed, Jul 17, 2019 at 7:33 PM Sonam Sharma <sonams1209@gmail.com> wrote:
>
> I took the backup using pg_dump with gzip option and restored it with psql.
It does not change the way you backed up, chances are when you
restored it the database cropped table and index bloating as already
mentioned.
The other, remote chance, is that you did not backed up all the
objects, so in this case you should show us your backup command line
(and restore one too), and also the output of commands like \l+, \dt+,
\di+ and differences you have found.
Luca