Re: Oracle to PostgreSQL - DWH

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: Oracle to PostgreSQL - DWH
Дата
Msg-id D0AA43BD-146A-4922-8752-A2787E9C3032@gmail.com
обсуждение исходный текст
Ответ на RE: Oracle to PostgreSQL - DWH  (<soumik.bhattacharjee@kpn.com>)
Список pgsql-admin
Дерево обсуждения
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..

 

В списке pgsql-admin по дате отправления: