4 ms·
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
by takacsroland 6y ago
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?
- outworlder 6y agoYMMV. 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.
- takacsroland 6y agoI see, thanks!
- tomnipotent 6y ago> 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.