| From: | Gurudutt Dhareshwar <gurudutt(dot)dhareshwar(at)gmail(dot)com> |
|---|---|
| To: | Amit jain <amit7(dot)jain(at)gmail(dot)com> |
| Cc: | soumik(dot)bhattacharjee(at)kpn(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Oracle to PostgreSQL - DWH |
| Date: | 2020-02-12 16:06:27 |
| Message-ID: | D637CA95-5DCB-4423-ABC0-58D580D8B9CE@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Would suggest using snowflakes for DWH
Regards,
Gurudutt Dhareshwar
(469-288-7845)
> On Feb 12, 2020, at 07:44, Amit jain <amit7(dot)jain(at)gmail(dot)com> wrote:
>
>
> Greenplum is best suited for DW workload,based on Postgresql open source and commodity hardware can also support this.
>
> Postgresql is OLTP DB.
>
> Amit Jain
> 9833777592
>
>> On Wed, Feb 12, 2020, 7:56 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
>> Hi Experts,
>>
>>
>>
>> Greetings!!
>>
>>
>>
>> Did anyone have some use cases for migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Oracle)
>>
>>
>>
>>
>>
>> Thanks..
>>
>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Allan Davis | 2020-02-12 16:24:23 | Re: Oracle to PostgreSQL - DWH |
| Previous Message | Amit jain | 2020-02-12 15:43:34 | Re: Oracle to PostgreSQL - DWH |