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 <laurenz.albe@cybertec.at>
Sent: Friday, January 24, 2020 9:43:38 PM
To: varinder gupta <varinder_gupta25@yahoo.co.in>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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