Re: Oracle to PostgreSQL - DWH

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(dot)bhattacharjee(at)kpn(dot)com wrote:
>
> 
> Migration is fine, but is PostgreSQL good for DWH use cases ?
>
> Can PostgreSQL support data warehousing loads?
>
> From: John Wiencek <jwiencek3(at)comcast(dot)net>
> Sent: woensdag 12 februari 2020 16:31
> To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
> Cc: pgsql-admin(at)lists(dot)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
> 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(dot)bhattacharjee(at)kpn(dot)com> <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..
>