Re: Need assistance in Oracle11g to Postgres migration
| От | Deepak Pahuja . |
|---|---|
| Тема | Re: Need assistance in Oracle11g to Postgres migration |
| Дата | |
| Msg-id | CH2PR10MB403765FF0A8514CE1B5D2E19D60E0@CH2PR10MB4037.namprd10.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: Need assistance in Oracle11g to Postgres migration (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Список | pgsql-admin |
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
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
> 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
В списке pgsql-admin по дате отправления: