Need assistance in Oracle11g to Postgres migration

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Need assistance in Oracle11g to Postgres migration

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
Reply | Threaded
Open this post in threaded view
|

Re: Need assistance in Oracle11g to Postgres migration

Laurenz Albe
On Fri, 2020-01-24 at 13:01 +0000, varinder gupta wrote:
> 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.

Something similar to your Oracle installation, perhaps.

The question is way too general for a good answer.

Yours,
Laurenz Albe



Reply | Threaded
Open this post in threaded view
|

Re: Need assistance in Oracle11g to Postgres migration

Deepak Pahuja .
It also depends on various factors like:

1. No of users.
2. Type of application oltp/dss etc
3. Replicated / non replicated
4. The processing capacity based on CPUs/cores

Start with basic configuration and check for performance , and slowly increase the capacity in steps.

There is a site where you can input parameters and get the suggested configuration. I don't have it now.

Thanks
Deepak

From: Laurenz Albe <[hidden email]>
Sent: Friday, January 24, 2020 9:43:38 PM
To: varinder gupta <[hidden email]>; [hidden email] <[hidden email]>
Subject: Re: Need assistance in Oracle11g to Postgres migration
 
On Fri, 2020-01-24 at 13:01 +0000, varinder gupta wrote:
> 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.

Something similar to your Oracle installation, perhaps.

The question is way too general for a good answer.

Yours,
Laurenz Albe



Reply | Threaded
Open this post in threaded view
|

Re: Need assistance in Oracle11g to Postgres migration

Bo Victor Thomsen
In reply to this post by varinder gupta

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