pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed assistance in Oracle11g to Postgres migration
4+ messages / 4 participants
[nested] [flat]
* Need assistance in Oracle11g to Postgres migration
@ 2020-01-24 13:01 varinder gupta <varinder_gupta25@yahoo.co.in>
0 siblings, 2 replies; 4+ messages in thread
From: varinder gupta @ 2020-01-24 13:01 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 RegardsVarinder Gupta
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Need assistance in Oracle11g to Postgres migration
@ 2020-01-24 13:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: varinder gupta <varinder_gupta25@yahoo.co.in>
1 sibling, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2020-01-24 13:43 UTC (permalink / raw)
To: varinder gupta <varinder_gupta25@yahoo.co.in>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Need assistance in Oracle11g to Postgres migration
@ 2020-01-24 15:59 Deepak Pahuja . <deepakpahuja@hotmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 4+ messages in thread
From: Deepak Pahuja . @ 2020-01-24 15:59 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; varinder gupta <varinder_gupta25@yahoo.co.in>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Need assistance in Oracle11g to Postgres migration
@ 2020-01-25 21:48 Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
parent: varinder gupta <varinder_gupta25@yahoo.co.in>
1 sibling, 0 replies; 4+ messages in thread
From: Bo Victor Thomsen @ 2020-01-25 21:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-01-25 21:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-24 13:01 Need assistance in Oracle11g to Postgres migration varinder gupta <varinder_gupta25@yahoo.co.in>
2020-01-24 13:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2020-01-24 15:59 ` Deepak Pahuja . <deepakpahuja@hotmail.com>
2020-01-25 21:48 ` Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox