From: Gurudutt Dhareshwar <gurudutt.dhareshwar@gmail.com>
To: Amit jain <amit7.jain@gmail.com>
Cc: soumik.bhattacharjee@kpn.com
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
Date: Wed, 12 Feb 2020 08:06:27 -0800
Message-ID: <D637CA95-5DCB-4423-ABC0-58D580D8B9CE@gmail.com> (raw)
In-Reply-To: <CAFBajrMXd=MpbR+MDP9iP1sjt_G5cc1mUakHViehmQ5BYXd75Q@mail.gmail.com>
References: <CAFBajrMXd=MpbR+MDP9iP1sjt_G5cc1mUakHViehmQ5BYXd75Q@mail.gmail.com>
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..
>>
>>
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: gurudutt.dhareshwar@gmail.com, amit7.jain@gmail.com, soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
In-Reply-To: <D637CA95-5DCB-4423-ABC0-58D580D8B9CE@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