Re:IBM creates 24-core Power chip so customers can exploit O...
by Tsarbomb on Friday December 16, 2022 @04:34PM
(#34020768)
Just curious how you are certain of the better performance and behaviour of Oracle given that Oracle does not allow disclosing of benchmarks without prior consent from them?
Re:IBM creates 24-core Power chip so customers can exploit O...
by slt2021 on Friday December 16, 2022 @04:38PM
(#34020799)
> CTE is optimization fence in postgres, which is not the case in oracle
Re:IBM creates 24-core Power chip so customers can exploit O...
by jeltz on Sunday December 18, 2022 @06:34AM
(#34036774)
It has not been an optimization fence for three years now. I was one of the co-authors of the patch which fixed that.
Re:IBM creates 24-core Power chip so customers can exploit O...
by scalatohaskell on Friday December 16, 2022 @04:44PM
(#34020877)
> CTE expression is an optimization fence in postgres, which is not the case in oracle.
generally not true since PG12
2. oracle does not need vacuum, unlike postgres
3. postgres has problems with many concurrent connections, thats why you need workarounds like pgbouncer. Oracle doesnt need that.
And same picture with almost any other feature - it is sort of "works" in postgres - but with crutches/workarounds, while in Oracle - stuff just works out of the box.
You dont need to search and install some obscure opensource extension to get the thing you want working, like you do in postgres world. and then keep updating that extension with every new version, etc