5 ms·
There is no optimizer that is capable of getting the correct result 100% of the time. Even Oracle with decades of costly engineering behind it requires query t
by alyandon 5y ago
There is no optimizer that is capable of getting the correct result 100% of the time. Even Oracle with decades of costly engineering behind it requires query tuning (either via explicit hints on the client side sql or via server side plan tuning) at any reasonably large scale.
I like Postgresql and use it when I can and I respect the Postgreql core dev team's adherence to principles but in this particular case I believe they are just inventing arguments to justify their unreasonable stance against allowing query hinting.
- _jal 5y agoSo "most of the time" means "100% of the time" where you live?
- stormbrew 5y agoI mean, I think this is just one of those things where it only matters rarely, but when it does it matters a lot.
- staticassertion 5y agoMaybe postgres isn't the right solution in those cases. If you need tight control over how your queries are executing you may not want an rdbms.
- kadoban 5y agoThat's possible I guess, but at least some other relational dbs do allow that control, so it's not like it's impossible.
- stormbrew 5y agoI don't think choices of things like this ever really come down to one thing like that. Not using an RDBMS might mean having to build a whole bunch of features you wouldn't otherwise have to.