Re: Need assistance in Oracle11g to Postgres migration

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

Get Outlook for Android<https://aka.ms/ghei36>
________________________________
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: Friday, January 24, 2020 9:43:38 PM
To: varinder gupta <varinder_gupta25(at)yahoo(dot)co(dot)in>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
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