Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time
Schedule

Presented by:

1f7511c5daf28a6d1a3519a086e67de3

Jobin Augustine

from Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 21 years of working experience as a consultant, Architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open Source communities, and his main focus area is database performance and optimization. He is a contributor to various Open Source Projects, an active blogger and loves coding in C++ and Python. Jobin holds a Masters in Computer Applications and joined Percona in 2018. Previously, he worked at OpenSCG for two years as Architect and was part of the BigSQL core team. Jobin worked at Dell as Database Senior Advisor for ten years and five years with TCS/CMC.

Speaker at many conferences
PGConf India, Almost every year till 2020
postgresconf 2019
PerconaLive 2019
pgconf.Eu 2019

Download slides

Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new versions of PostgreSQL which everyone should be aware about. This is a talk + small demonstrations of few cases how plan changes/behaves. This talk covers improvements in PostgreSQL 12. 1. Overview of Planner 2. Factors affecting the plan: costing 3. Selection of paths 4. Prepared statements and plan cache. 5. How plan changes with PostgreSQL versions. 6. Automatic elimination of unwanted joins. 7. CTE and Its optimization covering the latest improvements 8. Partition pruning 9. Run time optimizations 10. Optimizer support for functions, COST clause of CREATE FUNCTION

Date:
2020 February 28 - 11:45
Duration:
40 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2020
Language:
Track:
Application Developer
Difficulty:
Medium

Happening at the same time:

  1. Locks in Postgres
    2. Start Time:
    2020 February 28 11:45

    Room:
    Grand Victoria 1

  2. Real time data streaming in PostgreSQL
    3. Start Time:
    2020 February 28 11:45

    Room:
    Grand Victoria 2