Schedule - PGConf.EU 2019
The PostgreSQL Optimizer and indexes unleashed
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.