Here's how to tell how much space (on disk) a Postgres database takes:

SELECT pg_database.datname,  
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size  
  FROM pg_database;

Thanks to Matt Clarkson for the tip.