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.kell...@usb.ch> 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 > >
