| From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
|---|---|
| To: | Kellner Thiemo <thiemo(dot)kellner(at)usb(dot)ch> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL suitable? |
| Date: | 2017-12-19 14:30:41 |
| Message-ID: | CAHjZ2x5APmmoDy2FdOMQj_YN3bOM_Fe2my9CdNo44GY26W8B-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)kellner(at)usb(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2017-12-19 14:48:16 | Re: PostgreSQL suitable? |
| Previous Message | Chris Travers | 2017-12-19 14:26:03 | Re: PostgreSQL suitable? |