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

Schedule - PGConf.EU 2019

The PostgreSQL Optimizer and indexes unleashed

Date: 2019-10-15
Time: 09:00–17:00
Room: Foscolo
Level: Intermediate

The PostgreSQL optimizer is an important and sophisticated piece of software, which is often quoted but rarely understood. Let us put and end to this and explain, what really goes on behind the scenes. You will learn about the PostgreSQL cost model, basic as well as more advanced optimizations. In addition to that indexes will be covered in depth. In many cases indexes are key to good performance and therefore it makes sense to deal with them in great detail to efficiently speed up your databases.


Hans-Jürgen Schönig