I always do:\l+and then you can compare the size:new_one | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | *7869 kB* | pg_default | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| *7869 kB* | pg_default | | | | | postgres=CTc/postgres | | | template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| *7869 kB* | pg_default
-- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html