Re: PostgreSQL

Kellyn- I think I would further emphasize your item #3- Years of effort in optimizing the configuration. This holds true for Oracle and just about every other db, and even the best documented systems still seem to have tweaks fall through the cracks.

On Fri, Jan 6, 2023 at 10:34 AM Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> wrote:

> I'm going to jump in here and start with the reason why- Although Tim and
> I both do Oracle on Azure IaaS, we receive a lot of Oracle databases that
> fail migrating to PostgreSQL. The reasons that this commonly happens is as
> follows:
> 1. The team underestimated all the applications and connectors post the
> database migration that required refactoring. Oracle is never just a
> database- there's always more to consider.
> 2. The database housed complex PL/SQL functions and advanced Oracle
> features that weren't able, (and remember, I'm not the one who did the
> migration, just received the database back and hearing this second hand) to
> duplicate it with PostgreSQL.
> 3. The performance had years to be optimized in Oracle and refactoring
> takes considerable time and dedication. If the customer and the team
> performing the migration isn't willing to not just refactor but dedicate a
> full redesign to use the best of PostgreSQL to optimize the workload, that
> workload "explosion" can impact performance so significantly that it's
> unacceptable.
> 4. The flavor of PostgreSQL MATTERS. What EnterpriseDB Big Animal can
> handle is different than CosmosDB Hyperscale Citus and that's different
> than Amazon Redshift or what Yugabyte offers. Use the right PostgreSQL for
> the job. If I see one more 3000 MBPs Oracle workload attempted in a PaaS
> PostgreSQL that can only do 300MBPs max, I'm going to scream. :)
>
>
>
> *Kellyn Gorman*
> DBAKevlar Blog <http://dbakevlar.com>
> about.me/dbakevlar
>
>
>
> On Fri, Jan 6, 2023 at 4:37 AM Terrian Thomas J CTR DLA INFO OPERATIONS <
> dmarc-noreply_at_freelists.org> wrote:
>
>> 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