Conference Schedule - PGConf.EU 2019
How PostgreSQL tuning can profit from 20 years Oracle tuning
Time: 11:50 - 12:40
Tuning a database system mostly comes down to the same areas, no matter which database system it is about: Optimizer features/bugs, badly written SQL, understanding database parameters and as a final resort: Storage and operating system (mis-)configuration. PostgreSQL is no exception to that but when you try to tune PostgreSQL with a pure 20 years Oracle background there are some similarities but also major differences. One area which commonly is misunderstood is what optimizations the PostgreSQL optimizer is able to do and what it is (currently) not able to do. This is a hard lessons learned session of my long time Oracle DBA experience, with also some demos .