Journey of the DML queries
Presented by:
Vaibhav Dalvi
I am PostgreSQL database engine developer at EnterpriseDB since 2018. Works on several database internals projects of Postgres as well as EPAS(EnterpriseDB Postgres Advanced Server). Also, works on few open source extensions i.e. oci_dblink, mongo_fdw, mysql_fdw and hdfs_fdw.
Checkout the slides
This talk is in continuation with the talk presented in PGConf India, 2020, i.e. Journey of the Query from SELECT to Result set. Many of the users and ‘wanting to be postgres developers’ wonder what really happens when a SQL is issued over PSQL prompt and till the data is inserted/updated/deleted (i.e DML queries). During this presentation I will like to take the audience through the different phases of query when one types “INSERT INTO mytable VALUES (1, 2)†and same for UPDATE as well as DELETE operation. The presentation will first list out the phases (Parse, Analyse, Plan, Execution, etc.) and later go through each of the phase with abstract explanation for each of the phase and the output it supposed to produce. In my presentation I will try to keep it at an abstract level to extend the understanding to even a beginner.
- Date:
- 2023 February 23 - 14:00
- Duration:
- 45 min
- Room:
- Grand Victoria 1
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Engine Developers
- Difficulty:
- Easy
- How to identify and tune PostgreSQL performance issues using wait events
- Start Time:
- 2023 February 23 14:00
- Room:
- Robusta + Arabica
- Deep dive of usage of Postgres in Zerodha and our learnings
- Start Time:
- 2023 February 23 14:00
- Room:
- Grand Victoria 2