This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2019

How PostgreSQL tuning can profit from 20 years Oracle tuning

Date: 2019-10-17
Time: 11:50–12:40
Room: Parini
Level: Intermediate

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 .

Slides

The following slides have been made available for this session:

Speaker

Hervé Schweitzer