Try
Home   >   mailing lists

Re: Linux VM Sizing - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Linux VM Sizing
Date
Msg-id CAN6TVjkShQro8RyfjHk5cDPEtNrDhj_dafnVMVZeQuJuMKbgaw@mail.gmail.com
Whole thread Raw
In response to Linux VM Sizing  (Sam Stearns <sam.stearns@dat.com>)
List pgsql-admin
Tree view
I should clarify that we are converting to Postgres.

On Mon, Jul 28, 2025 at 4:41 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

Based on the above can anyone give advice as to how to size the CPU / memory of the Linux VM, please?

Thanks,

Sam

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com




--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com


pgsql-admin by date:

Previous
From: Sam Stearns
Date:
Subject: Linux VM Sizing
Next
From: Rui DeSousa
Date:
Subject: Re: Why many more deadlocks after upgrade to PG 17.5?