Journey of the Query from SELECT to Result set.
No video of the event yet, sorry!
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 result is shown on prompt(specially SELECT queries). During this presentation I will like to take the audience through the different phases of query when one types “SELECT * FROM mytable WHERE b = 20”. The presentation will first list out the phases 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 an beginner.
- 40 min
- PGConf India, 2020
- Database Engine Developers