I have a PostgreSQL database, I made a backup copy of it and then I have installed the copy on another machine.
I noticed that the database size calculated with the query:
Code:
select pg_database_size ('testdb'), pg_size_pretty (pg_database_size ('testdb'));
are significantly different on the two machines (the machine base is about twice the size).
I tried to make the VACUUM command but the dimensions have not changed.
What could be the cause of this difference?
There are other commands besides VACUUM to compact the database?
Thanks.