RE: [Non-DoD Source] Re: PostgreSQL

From: Terrian Thomas J CTR DLA INFO OPERATIONS <dmarc-noreply_at_freelists.org>
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
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  

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
To: oracle-l <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org> > Subject: [External] : PostgreSQL  

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



--
http://www.freelists.org/webpage/oracle-l


  • application/pkcs7-signature attachment: smime.p7s
Received on Fri Jan 06 2023 - 16:38:23 CET

Original text of this message