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 1ivTIK-0003jn-L5 for pgsql-admin@arkaria.postgresql.org; Sat, 25 Jan 2020 21:48:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ivTIG-0002hH-NP for pgsql-admin@arkaria.postgresql.org; Sat, 25 Jan 2020 21:48:40 +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 1ivTIG-0002h1-2v for pgsql-admin@lists.postgresql.org; Sat, 25 Jan 2020 21:48:40 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ivTI9-0004EE-62 for pgsql-admin@lists.postgresql.org; Sat, 25 Jan 2020 21:48:38 +0000 Received: by mail-wm1-x335.google.com with SMTP id p9so2947408wmc.2 for ; Sat, 25 Jan 2020 13:48:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=CJ0aXURW8PvzF60b40LOfMxI8VrkAtizRC+nz1MWOZE=; b=l3za3dnrKv5IEifMLhsfjawm8XIylPf+kBpOuMq44smJj/rstECQ4iesWpH5enexNk OiJd8QqeY8vqex4xYPnHgAnVZioeosLbsjen710532m4lLfXk+/c+691kJraQ9QW4KUf B9IqP1Q6xBwvPvjH7dZA1nJPNx24XxhOUHBeCNcBkev46g3Sw8HJCWzccPjk8yTThKCd a+b0TIidjHwyqsWfguXUhZGNizPwfBy3bZcOqasFXbISUAL4aBICrAlAxxOgtTVrMV7C h4f2FWfa+IdSJWL5CtaZk4pfZrTWOtOZc4ppSztMYlMqDl3DHIZmnI+2WQJgIEdicD4j h35w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=CJ0aXURW8PvzF60b40LOfMxI8VrkAtizRC+nz1MWOZE=; b=UIHUo5Z2qLYDvP2nM8OYT1VcAP1oxU+2Lp7SzfhXq0ExIKXxzFQjADKXNGYjd/CC52 wDZs5nd+Z7UMJ8YUd+6SQXeuMVToZ7yZHIUeeCSTpNunV5AKRpwSRKs7jMaDwps7mWn5 LbntJRFZnhub+ZQIQAaAgZZZ3ZVtQVd2TzuSKVKPBflMB9qDJ7yRTTI7ANN3YxRVUuqt oIjkAfVGRIrfWGa2oSgB8d5mWd+I235hSyKqUkjgB2vaGNj3tma9ANY6vn5OuQqkkBQR pK3Zq6p5iJldEjRtBRyVib9ysbXyn2HSJMFImjK/XIOMnII5qTOnbQrNh+Q/38gpALII 8Ttg== X-Gm-Message-State: APjAAAUMN2lEwyUXQPjBVMH1r7q9Gy+uBSwBItHg/Y4OycEeupefR0ZY DPPN9WfgSFjFKWk6fVFeOdMsLERh X-Google-Smtp-Source: APXvYqwmGjue0Qm8itlhCvElxx8XIuERc+JfZq/i6zc104JAPxwrildLYeDxCfFmo2xQ18eb2m1D2A== X-Received: by 2002:a1c:1fd0:: with SMTP id f199mr5543392wmf.113.1579988910875; Sat, 25 Jan 2020 13:48:30 -0800 (PST) Received: from [10.0.0.178] (062066194211.dynamic.telenor.dk. [62.66.194.211]) by smtp.gmail.com with ESMTPSA id y20sm3787253wmj.23.2020.01.25.13.48.30 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 25 Jan 2020 13:48:30 -0800 (PST) Subject: Re: Need assistance in Oracle11g to Postgres migration To: pgsql-admin@lists.postgresql.org References: <2033117469.13483913.1579870903308.ref@mail.yahoo.com> <2033117469.13483913.1579870903308@mail.yahoo.com> From: Bo Victor Thomsen Message-ID: <372c13ee-b8ba-fb21-fe9b-a08b2df8028e@gmail.com> Date: Sat, 25 Jan 2020 22:48:45 +0100 User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.3.1 MIME-Version: 1.0 In-Reply-To: <2033117469.13483913.1579870903308@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------CFFD905EEA36D6175E7A25DE" Content-Language: en-GB List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------CFFD905EEA36D6175E7A25DE Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit You can try this: https://pgtune.leopard.in.ua/#/ Just remember: The parameters are "Somewhere in the ballpark" - meaning that: They are probably o.k., not superb. -- Med venlig hilsen / Kind regards Bo Victor Thomsen Den 24-01-2020 kl. 14:01 skrev varinder gupta: > Dear Team, > > We are planning to migrate Oracle 11g (200 GB) to Postgres. > What should be the virtual machine configuration that will host the > Postgres? > - the number of cores, RAM and Disc space for the virtual machine. > > > > Warm Regards > Varinder Gupta -- Med venlig hilsen / Kind regards Bo Victor Thomsen --------------CFFD905EEA36D6175E7A25DE Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit

You can try this: https://pgtune.leopard.in.ua/#/

Just remember: The parameters are "Somewhere in the ballpark" - meaning that: They are probably o.k., not superb.

-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen
Den 24-01-2020 kl. 14:01 skrev varinder gupta:
Dear Team,

We are planning to migrate Oracle 11g (200 GB) to Postgres.
What should be the virtual machine configuration that will host the Postgres?
- the number of cores, RAM and Disc space for the virtual machine.



Warm Regards
Varinder Gupta
-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen
--------------CFFD905EEA36D6175E7A25DE--