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 1j1u8j-0006ue-HA for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 15:41:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j1u8i-0001xO-C2 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 15:41:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1u8i-0001us-2N for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 15:41:24 +0000 Received: from mail-yw1-xc34.google.com ([2607:f8b0:4864:20::c34]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j1u8f-0002YV-RL for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 15:41:23 +0000 Received: by mail-yw1-xc34.google.com with SMTP id t141so1028627ywc.11 for ; Wed, 12 Feb 2020 07:41:21 -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=UJSjuryx8+/YPU0S2UH5UaiYh2AWTmnjxBaHHeb0+NE=; b=UKi4l0IjQ8mKrNWt7a662uZVhJSfaXmey+9c5TFjQJfKIe3EtGYtyKA4L4fFpwchY9 jD5KErt6BBKhR/fIPQy2iJES8L6eN5Ng0w6WdHcGc4soXGv341ZNAxPMRt8V5ztpMzEB Z23bX0GFxPFhFHdbBVQF/oy868rqNnCJ/LN9zgQtpgkHsTQoI2gXpf6bZGPTp3N0IQ1q WcoA8sVTCeqIXQvqFSwIZwB2qTTBLF9gFfUACzQpeCeKTPMfGfbTZN0RWTGMykAGauKn NYy+lyWJt7rnNrZY+m7dmFvfceeM2z+NJkEN7Lh7BM3GNcVjULOvSLWkATkHZo4ZbpCp 2QXw== 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=UJSjuryx8+/YPU0S2UH5UaiYh2AWTmnjxBaHHeb0+NE=; b=fXDRcZgI9d4QnmjVbkJ8aU9VLri6ctyILV/BMPE52K0PwX5abQ5Q7t2ocd1ckyugVF e3gqPKoHnzMWBT2wznfaELAhNK3g1JF5e18M27Fx+/WRAhW0DrokXoFOJJX9z9hi3Ewi LOqHbYyU7CoZ6yoLyb3K2x68vvop/vkFYqZwMPywS/q+S37LXmcwJSyJVvbkJGcOaXWw zL891FLOAGA+cDAzRkmWy6rE0FBOki0gJR5DgR8JqwmI/X49aHQ7d0iS6bjr290kw29K iEm3P3CU5kYlpY7H06+hjuxyqEP/N1nQxx6r6/m65XZTo+lxE6/ds5g6nUYvQA/R1tjG pGGg== X-Gm-Message-State: APjAAAWkCRtZ/BKc30sJoKlKF+ia7GmILjhnCUXMEKqGzUmFze7qHXQH TIKI5bpamyeE5fdI9TnYggpExtZV X-Google-Smtp-Source: APXvYqzQBqEnKJEziX3sb7zegoW1hLIildgJyLHShnx7y42Z30XcCcnshZVieQVrP3DyglZPLo/rrg== X-Received: by 2002:a0d:e102:: with SMTP id k2mr10904824ywe.163.1581522078882; Wed, 12 Feb 2020 07:41:18 -0800 (PST) Received: from ?IPv6:2603:9000:f609:a03d:8d3d:7d3b:efcc:3d89? ([2603:9000:f609:a03d:8d3d:7d3b:efcc:3d89]) by smtp.gmail.com with ESMTPSA id l202sm295396ywb.89.2020.02.12.07.41.18 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 12 Feb 2020 07:41:18 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-A8D9852D-EF3B-4211-8261-B98220D4028A Content-Transfer-Encoding: 7bit From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Oracle to PostgreSQL - DWH Date: Wed, 12 Feb 2020 10:41:16 -0500 Message-Id: References: <2A91BEF8171A5349931391E0C721CC538530CA0E@CPEMS-KPN501.KPNCNL.LOCAL> Cc: jwiencek3@comcast.net, pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <2A91BEF8171A5349931391E0C721CC538530CA0E@CPEMS-KPN501.KPNCNL.LOCAL> To: soumik.bhattacharjee@kpn.com X-Mailer: iPad Mail (17D50) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-A8D9852D-EF3B-4211-8261-B98220D4028A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Then you should possibly look at Greenplum, which is a PostgreSQL based syst= em designed for data warehouses. True, they lag behind PostgreSQL versions c= onsiderably, but if your concern is data warehouses, that=E2=80=99s probably= the way to go. =E2=80=94 Jay Sent from my iPad > On Feb 12, 2020, at 10:35 AM, soumik.bhattacharjee@kpn.com wrote: >=20 > =EF=BB=BF > Migration is fine, but is PostgreSQL good for DWH use cases ? > =20 > Can PostgreSQL support data warehousing loads? > =20 > From: John Wiencek =20 > Sent: woensdag 12 februari 2020 16:31 > To: Bhattacharjee, Soumik > Cc: pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.org > Subject: Re: Oracle to PostgreSQL - DWH > =20 > EnterpriseDB has a product called Migration Toolkit (MTK) that can do this= . > =20 > =20 > John >=20 >=20 > On Feb 12, 2020, at 8:25 AM, wrote: > =20 > Hi Experts, > =20 > Greetings!! > =20 > Did anyone have some use cases for migrating Oracle to PostgreSQL in conte= xt to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Or= acle) > =20 > =20 > Thanks.. > =20 --Apple-Mail-A8D9852D-EF3B-4211-8261-B98220D4028A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 wa= rehouses, that=E2=80=99s probably the way to go.
=E2=80=94
Jay=

Sent from my iPad

On Feb 12, 2020, at 10:35 AM, soumik.bhattacharjee@kpn.co= m wrote:

=EF=BB=BF =

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 f= or migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) consi= dering 5TB to 8TB database size (Source-Oracle)

 

 

Thanks..

 

= --Apple-Mail-A8D9852D-EF3B-4211-8261-B98220D4028A--