I think that table partitioning isn't suitable yet for a large number of partitions. Or a large number of partial indexes.
This will be a challenge too.
Il 19 dic 2017 15:07, "Kellner Thiemo" <thiemo.kellner@xxxxxx> ha scritto:
Hi
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
