| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL suitable? |
| Date: | 2017-12-19 14:48:16 |
| Message-ID: | 2f0ca6b6-be91-2271-da47-52fd6cf4bc39@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 19.12.2017 um 15:07 schrieb Kellner Thiemo:
> 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
>
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.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2017-12-19 14:50:46 | Re: PostgreSQL suitable? |
| Previous Message | Vincenzo Romano | 2017-12-19 14:30:41 | Re: PostgreSQL suitable? |