Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1uX6-0007fz-8A for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 16:06:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j1uX3-0002bu-OJ for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 16:06:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1uX3-0002bn-5G for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 16:06:33 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j1uX0-00012d-Cu for pgsql-admin@postgresql.org; Wed, 12 Feb 2020 16:06:31 +0000 Received: by mail-pl1-x634.google.com with SMTP id b22so1115178pls.12 for ; Wed, 12 Feb 2020 08:06:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=mO8/nCLBrOFlxT1LN6+ZpNtwl7dpqxO5EVQyBVl7O80=; b=blTm6WXZqyJ/uLiZ7EnuBtvkdcl37b3q8ELWism6lbLi1CnL4gxDH02qeukMhnbbQL Adq+E8ShxVdJiv96Vy4Lct9T8AjhZPsuJlPKzWARh4HQWkayrSZlS6+2GmbieX7O6ocR mEgYcnN9UcQnWtvcZjY6wmQXbLfeplTQFoI8xXx7NyBpR55SNfL1nRtYRe3of97JfutL LGLXIPRN2vaWDzCQmN0YyrU6ru3XlXsAEs7noagFp7QRUWbLZkIWvumBM9B1j2L1khBS T2yW6Vc+5pqXXd8aHqdx5ACr+JFcwR4LB3+ND1RV5rdLHzcAN+YRJodiMd3d634IH7PO IvHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=mO8/nCLBrOFlxT1LN6+ZpNtwl7dpqxO5EVQyBVl7O80=; b=gTM/iapaV8H3X9l/3cmey4G7n3QyG1SyOdVLEAkmLyf/Sl7V8yAxCDtQ4QcFZ28SpP rxZv6gJcBgJ2bumYLpmFfZeY8Exy4tEQlDzACKCk8ZYRf38WMkmaIkx9B0WagM7zmnTv NmnaY1ky8uNnpvbL2M0WlTYW7WJKVWMMAyz32Bra0vwLnDdsodywBerp/Jpr10HZ+4gB IRME7PgdlFmcrrjOpnfJ63SG2ZOAhFYoBXSJhZyM9p29Ace9tsydXBQMlIbTFwtoGOPk q3tNLJYGr7pAcNqnu9KwKIHjSosgcfmCJ6jRZf4KQjwwEj3yV6z61bpYMmZAPeBThlvW HXUw== X-Gm-Message-State: APjAAAXnq3wWP0y3BEMqYwzktEhaN2Whmbftyw12w2Bmh/kORwGIhnNI iKvtlZwH2PmqFzFn2I5mE9k= X-Google-Smtp-Source: APXvYqy0Zip3UTMGG1WU2miBL7PJTL7v6+1tiPLsNZqm//zzxLQPMx4mRKpERH/b1XQQNcDGx/8Ylw== X-Received: by 2002:a17:902:8642:: with SMTP id y2mr8893989plt.306.1581523588863; Wed, 12 Feb 2020 08:06:28 -0800 (PST) Received: from ?IPv6:2601:644:4400:e940:7c79:e5e:5a85:d7ea? ([2601:644:4400:e940:7c79:e5e:5a85:d7ea]) by smtp.gmail.com with ESMTPSA id u13sm748719pjn.29.2020.02.12.08.06.27 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 12 Feb 2020 08:06:28 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-1C12B3AD-1984-44DC-8438-8BB31AD7BBB7 Content-Transfer-Encoding: 7bit From: Gurudutt Dhareshwar Mime-Version: 1.0 (1.0) Subject: Re: Oracle to PostgreSQL - DWH Date: Wed, 12 Feb 2020 08:06:27 -0800 Message-Id: References: Cc: soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org In-Reply-To: To: Amit jain X-Mailer: iPhone Mail (17D50) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-1C12B3AD-1984-44DC-8438-8BB31AD7BBB7 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Would suggest using snowflakes for DWH Regards,=20 Gurudutt Dhareshwar=20 (469-288-7845) > On Feb 12, 2020, at 07:44, Amit jain wrote: >=20 > =EF=BB=BF > Greenplum is best suited for DW workload,based on Postgresql open source a= nd commodity hardware can also support this. >=20 > Postgresql is OLTP DB. >=20 > Amit Jain > 9833777592 >=20 >> On Wed, Feb 12, 2020, 7:56 PM wrote: >> Hi Experts, >>=20 >> =20 >>=20 >> Greetings!! >>=20 >> =20 >>=20 >> Did anyone have some use cases for migrating Oracle to PostgreSQL in cont= ext to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-O= racle) >>=20 >> =20 >>=20 >> =20 >>=20 >> Thanks.. >>=20 >> =20 --Apple-Mail-1C12B3AD-1984-44DC-8438-8BB31AD7BBB7 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Would suggest using snowflakes for DWH
<= br>
Regards, 

Gurudutt Dhareshwar&nb= sp;
(469-288-7845)

On Feb 12, 2020, at 07:44, Amit jain <amit7.jain@gmail.com>= wrote:

=EF=BB=BF
Greenplum is best suited for DW workload,based o= n Postgresql open source and commodity hardware can also support this.

Postgresql is OLTP DB.

Amit Jain
98337775= 92

On Wed, Feb 12, 2020, 7:56 PM <soumik.bhattacharjee@kpn.com> wrote:

Hi Experts,=

 

Greetings!!=

 

Did anyone have some use cases f= or migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) consi= dering 5TB to 8TB database size (Source-Oracle)

 

 

Thanks..

 

= --Apple-Mail-1C12B3AD-1984-44DC-8438-8BB31AD7BBB7--