We are developing a data warehouse of which the integration layer will start with over 100 TB of data. There are not many entities though we probably can partition and foremost we should use inheritance for the lab results. I just was wondering if PostgreSQL was able to cope with. In case it depends on the modelling kind, we have not yet decided between classic erd, anchor modelling and data vault.
Does someone have experience with such a set up?
Kind regards
Thiemo
depends at least on the data and the workload. pg10 contains better solutions for table-partitioning, up to 1000 (maybe more) child-tables arn't that problem. We have customers in that range.