I guess the restore cleared the bloat from the table.
\dt+
\di+
If you run the above commands from the terminal, you would see diff in sizes of the. objects.
Also querying pg_stat_all_tables you might see “dead” tuples in old tables which would have cleaned up now.
Also if there were any large temp objects or queries using temp files would have cleared and hence reclaimed disk.
If none of these are true, then I guess experts would pitch in.
On Wed, 17 Jul 2019 at 10:33 PM Sonam Sharma <sonams1209@xxxxxxxxx> wrote:
I have restored database and the db size of source was around 55gb and after restore the db size of Target is 47gb.How to confirm if restore was successful or not ?The table count is also same.
Vijay
