Hello All, I need your assistance with the following tasks: 1)How can

Question

Hello All, I need your assistance with the following tasks: 1)How can

I migrate database links from Oracle to PostgreSQL using ora2pg?

2)How can I determine the appropriate RAM and CPU requirements for both the source and destination before performing an ora2pg migration? Specifically, is there a calculation method to determine the RAM and CPU based on the database size and application usage? For example, guidelines or formulas to determine the RAM and CPU requirements for databases ranging from 50 GB to 2 TB.

#programming #russian

0

31.07.2024

5 ответов

28 просмотров

N@R£N Автор вопроса

Stefanie Janine Stölting
For the PostgreSQL configuration part, my blog pos...

Ok thanks

0

1 месяц назад

Krond

That's more up to metrics of the server under load. Even with huge databases but simple queries you can get along with a meager setup.

0

1 месяц назад

N@R£N Автор вопроса

Krond
That's more up to metrics of the server under load...

Is it depends on application usage?

0

1 месяц назад

Krond

N@R£N
Is it depends on application usage?

No, database complexity. Simple database with easy queries and small joins will work fine even on 1Gb RAM. Add wider tables, multiple indexes, huge joins — everything will raise memory demand.

0

1 месяц назад

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

For the PostgreSQL configuration part, my blog post might be usable: https://proopensource.it/blog/postgresql-configuration But for detailed stuff more information would be needed, something where you might want to hire an expert. And you can't import database links. In PostgreSQL you need a foreign data wrapper to access external sources. These have to be installed. There is one available to access Oracle: oracle_fdw.

0

1 месяц назад

169 похожих чатов

Hello All, I need your assistance with the following tasks: 1)How can

5 ответов

Похожие вопросы