Find out total download and final database sizes

maschinenmensch / edifice

A database of the built environment in Chicago

5 stars 1 forks source link

Find out total download and final database sizes #13

Open derekeder opened 11 years ago

derekeder commented 11 years ago

Once we get all of our datasets added, it would be good to tell the users some useful stats on the readme:

total download size of all files
total size of the postGIS database footprint

mccc commented 11 years ago

We can figure out a lot of the aggregate download size via wget --spider, which will make it to the file and spit out the size without downloading it. PostGIS footprint size will be some more tricky postgres command.

derekeder commented 11 years ago

in the downloads folder, use

du -sh .

to determine size of downloads once we have everything added

mccc commented 11 years ago

\l+ will show each database's size in MB from the psql shell.