Assuming I want to build a web based data repository to store and serve
all different kinds of datasets, possibly holding up to 1 million
different datasets (timeseries, bulk data, etc.) ranging from 1kB to 1MB
in size. Would it be a good idea to do this using a Postgresql database
or should only the meta data of those datasets be stored using
Postgresql and the data itself simply by using files for each dataset?

Any help would be appreciated.

Many thanks

Andre