From: John Scalia <jayknowsunix@gmail.com>
To: soumik.bhattacharjee@kpn.com
Cc: jwiencek3@comcast.net
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
Date: Wed, 12 Feb 2020 10:41:16 -0500
Message-ID: <D0AA43BD-146A-4922-8752-A2787E9C3032@gmail.com> (raw)
In-Reply-To: <2A91BEF8171A5349931391E0C721CC538530CA0E@CPEMS-KPN501.KPNCNL.LOCAL>
References: <2A91BEF8171A5349931391E0C721CC538530CA0E@CPEMS-KPN501.KPNCNL.LOCAL>
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@kpn.com wrote:
>
>
> Migration is fine, but is PostgreSQL good for DWH use cases ?
>
> Can PostgreSQL support data warehousing loads?
>
> From: John Wiencek <jwiencek3@comcast.net>
> Sent: woensdag 12 februari 2020 16:31
> To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> Cc: pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.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.bhattacharjee@kpn.com> <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..
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, soumik.bhattacharjee@kpn.com, jwiencek3@comcast.net, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
In-Reply-To: <D0AA43BD-146A-4922-8752-A2787E9C3032@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox