Re: Oracle to PostgreSQL - DWH

[John Scalia <jayknowsunix@xxxxxxxxx>]

Then you should possibly look at Greenplum, which is a PostgreSQL based system designed for data warehouses. True, they lag behind PostgreSQL versions considerably, but if your concern is data warehouses, that’s probably the way to go.

—

Jay

Sent from my iPad

On Feb 12, 2020, at 10:35 AM, soumik.bhattacharjee@xxxxxxx wrote:



Migration is fine, but is PostgreSQL good for DWH use cases ?

 

Can PostgreSQL support data warehousing loads?

 

From: John Wiencek <jwiencek3@xxxxxxxxxxx>
Sent: woensdag 12 februari 2020 16:31
To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Oracle to PostgreSQL - DWH

 

EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.

 

 

John

On Feb 12, 2020, at 8:25 AM, <soumik.bhattacharjee@xxxxxxx> <soumik.bhattacharjee@xxxxxxx> 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..