Re: Linux VM Sizing
| От | Ron Johnson |
|---|---|
| Тема | Re: Linux VM Sizing |
| Дата | |
| Msg-id | CANzqJaBjrVHymyrP6=O9dVxz6ihWssQc2xPWXBrz_DnHW6Nm_A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Linux VM Sizing (Sam Stearns <sam.stearns@dat.com>) |
| Список | pgsql-admin |
On Mon, Jul 28, 2025 at 7:42 PM Sam Stearns <sam.stearns@dat.com> wrote:
Howdy,We are sizing a Linux VM to migrate our Oracle production database to. We are currently running on an Oracle Database Appliance. Oracle CPU / memory usage stats are:CPU % usage - 25% of 20 cores / 40 threads (Intel® Xeon® S4314 processor)Memory % usage - 100% usage of 600G SGA
Linux uses all available cache; is Oracle different? (IOW, would it also use 100% of 800GB?)
Based on the above can anyone give advice as to how to size the CPU / memory of the Linux VM, please?
Our 8TB Oracle DB was 6TB when migrated to PG 12 (this was a while ago) and the AWS RDS Postgresql instance (which was spec'd -- before I got to the project -- the same as the on-prem Linux server since the Oracle server ran 60-70%) was constantly less 10% of capacity in CPU and RAM.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-admin по дате отправления: