| From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL suitable? |
| Date: | 2017-12-19 14:50:46 |
| Message-ID: | CAHjZ2x5XAahW7Rj+zW57Eeq9wb1-1C4=j72r+vob501B1WgW9Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've not tested PG10. But it's not released for production yet!
Il 19 dic 2017 15:48, "Andreas Kretschmer" <andreas(at)a-kretschmer(dot)de> ha
scritto:
>
>
> 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 | Alvaro Herrera | 2017-12-19 14:55:47 | Re: PostgreSQL suitable? |
| Previous Message | Andreas Kretschmer | 2017-12-19 14:48:16 | Re: PostgreSQL suitable? |