Re: Oracle to PostgreSQL - DWH - Mailing list pgsql-admin

From Gurudutt Dhareshwar
Subject Re: Oracle to PostgreSQL - DWH
Date
Msg-id D637CA95-5DCB-4423-ABC0-58D580D8B9CE@gmail.com
Whole thread Raw
In response to Re: Oracle to PostgreSQL - DWH  (Amit jain <amit7.jain@gmail.com>)
List pgsql-admin
Would suggest using snowflakes for DWH

Regards, 

Gurudutt Dhareshwar 
(469-288-7845)

On Feb 12, 2020, at 07:44, Amit jain <amit7.jain@gmail.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.bhattacharjee@kpn.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..

 

pgsql-admin by date:

Previous
From: Amit jain
Date:
Subject: Re: Oracle to PostgreSQL - DWH
Next
From: Allan Davis
Date:
Subject: Re: Oracle to PostgreSQL - DWH