News for hackers. Stuff that matters.

A comment on Oracle vs. PostgreSQL: First Glance. Parent comment

Re:Oracle vs. PostgreSQL: First Glance by takacsroland on Monday May 04, 2020 @05:56PM (#23073801)
In fact, my company wants to spare the expenses on Oracle. This is the main reason for migrating. We'll see how it works out. You are not the first one to point out postgre's optimizer. Is it really that bad?
[ Parent | on HN ]
Re:Oracle vs. PostgreSQL: First Glance by outworlder on Monday May 04, 2020 @06:15PM (#23074000)
YMMV. That depends on your workload, how your data is structured and a million other things. I know a few shops with heavy usage that couldn't be happier.

It may require handholding if you are not happy with the plans it is generating. Also the quality of the query planner results will depend a lot on how up to date the statistics are.

[ Parent | on HN ]
Re:Oracle vs. PostgreSQL: First Glance by takacsroland on Wednesday May 06, 2020 @12:46PM (#23093252)
I see, thanks!
[ Parent | on HN ]
Re:Oracle vs. PostgreSQL: First Glance by tomnipotent on Monday May 04, 2020 @06:25PM (#23074092)
> Is it really that bad?

It's not that it's bad, but Oracle/MSSQL have had the benefit of decades of corporate muscle, researchers, and Fortune 500 clients to help pave the way.

[ Parent | on HN ]