RE: [Non-DoD Source] Re: PostgreSQL
Date: Fri, 6 Jan 2023 15:38:23 +0000
Message-ID: <BN8P111MB190882492D56FC5B450FE331B1FB9_at_BN8P111MB1908.NAMP111.PROD.OUTLOOK.COM>
Ok. The current Oracle databases are 19c in AWS (RDS) and we are staying in AWS. OLTP and Data warehousing. No RAC. Lots of stored procedures, functions, materialized views, scheduler jobs. Lots of partitioning. No replication. No DataGuard. A couple of thousand connections at a time. 14 databases. Around 50TB total disk space.
From: Jeremiah Wilton <jcwilton93_at_earlham.edu>
Sent: Friday, January 6, 2023 10:00 AM
Well this is a fact free discussion so far….
What kinds of workloads? TPS? Read/write ratios? How much PL/SQL and stored procedures, functions, packages etc.? What other features, like replication, partitioning, IOTs, RAC, DataGuard, etc.? Give us something to work with here!
Jeremiah
Sent from my iPhone
On Jan 6, 2023, at 5:09 AM, Jeff Smith <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org> > wrote:
My initial thought is you’re moving in the wrong direction.
From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of Terrian Thomas J CTR DLA INFO OPERATIONS
Sent: Friday, January 6, 2023 7:37 AM
Here are some open ended question for the group…We are starting to look at migrating our databases from Oracle to PostgreSQL. I know nothing about PostgreSQL.
Has anyone done a pro’s and con’s list of Oracle vs. PostgreSQL?
Anyone have a lesson’s learned list from migrating from Oracle to PostgreSQL?
Any thoughts/comments on PostgreSQL?
I kind of think that you get what you pay for…wouldn’t that mean that Oracle would outperform PostgreSQL in every way?
Any comments would be appreciated.
Tom
To: jeff.d.smith_at_oracle.com
Cc: Terrian, Thomas J CTR DLA INFO OPERATIONS (USA) <Tom.Terrian.ctr_at_dla.mil>; oracle-l <oracle-l_at_freelists.org>
Subject: [Non-DoD Source] Re: PostgreSQL
To: oracle-l <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org> >
Subject: [External] : PostgreSQL
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 06 2023 - 16:38:23 CET