Hi guys could any share ehat are the functionality changes difference between oracle and postgresql i remembered where less could any one add few changes here
Loading
Hi guys could any share ehat are the functionality changes difference between oracle and postgresql i remembered where less could any one add few changes here
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Sep 30, 2022, 6:44 AM
PLSQL (oracle) is compiled and optimized code (your code is compiled and that's where the INVALID concept comes in).
PLPGSQL (PG) is NOT. It is interpreted. You can pretty much assume a 10-20% overhead.
In fact, my rough estimate is about that across the board. (So, in perspective, if your DB is running at 50% CPU w/Oracle, Well, you will likely be above 60% with PG).
Finally, they are 2 different beasts. Oracle "teaches you to commit more often..." PG Dislikes procedures that commit!
It's a completely different beast.