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.
What am I missing here?
% vacuumdb --full foo
vacuumdb: vacuuming database "foo"
% pg_dump -Fd -f backup_foo.d -U postgres foo
% createdb bar
% pg_restore -Fd backup_foo.d -U postgres -d bar
% psql -U postgres -c '\x' -c "SELECT pg_database_size( 'foo' ),
pg_database_size( 'bar' );" template1
Expanded display is on.
-[ RECORD 1 ]----+-----------
pg_database_size | 2686571167
pg_database_size | 2690212355
% vacuumdb --full bar
vacuumdb: vacuuming database "bar"
% psql -U postgres -c '\x' -c "SELECT pg_database_size( 'foo' ),
pg_database_size( 'bar' );" template1
Expanded display is on.
-[ RECORD 1 ]----+-----------
pg_database_size | 2686571167
pg_database_size | 2688193183
% psql -c 'select version();' -U postgres template1
version
-----------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 11.3 on amd64-portbld-freebsd12.0, compiled by FreeBSD
clang version 6.0.1 (tags/RELEASE_601/final 335540) (based on LLVM
6.0.1), 64-bit
(1 row)
