How PostgreSQL parses the query and constructs the Parse Tree?

System Design for Beginners: arpitbhayani.me/sys-design
System Design for Experienced Engineers: arpitbhayani.me/masterclass
Redis Internals: arpitbhayani.me/redis
Build Your Own Redis / DNS / BitTorrent / SQLite - with CodeCrafters.
Sign up and get 40% off - app.codecrafters.io/join?via=...
In the previous video, we looked at what happens internally when a client connects to a Postgres database and its per-client process model in depth.
In this video, look into the source code to understand what happens when Postgres receives a SQL query from the client, and how it parses the query to create the parse tree.
PostgreSQL per-client process model - • PostgreSQL connection ...
PostgreSQL Internals Playlist - • PostgreSQL connection ...
Database Engineering Playlist - • PostgreSQL connection ...
System Design Playlist - • How DNS really works a...
Other links
CS Engineering and Software Development books that I have read
arpitbhayani.me/bookshelf
Research papers that I have read
arpitbhayani.me/papershelf
Newsletter: arpit.substack.com
LinkedIn: / arpitbhayani
Twitter: / arpit_bhayani
Until next time, stay awesome :)
Yours truly,
Arpit
arpitbhayani.me
#AsliEngineering

[@jaya_surya]

Thanks

[@AsliEngineering]

Thank you so much for this warm gesture 🙌 it really means a ton.

[@artu-hnrq]

Nice overview! Thanks for sharing

[@ankurc854]

Thanks for sparking the curiosity :)

[@mayank2662]

Super informative. This got me curious about these interesting stuff again, Thanks Arpit!

[@dharins1636]

Very Detailed video, thanks for diving in

[@AsliEngineering]

Thanks a ton!

[@sparsh724]

This video was super informative, Arpit!!!

[@AsliEngineering]

Thank you Sparsh!

[@physicsakhada592]

Deadlocks and transaction please in depth😊

[@SaketAnandPage]

How did you make this Red Color Pen with sparkles in Good Notes?

[@kritibindra4232]

This is awesome! I really love how you tell how you were able to find things like scan.l being converted to scan.c etc. It helps us in understanding how to go through the code files. Arpit, can you cover query execution plan of DBs and how can they affect performance? Or have you already covered in previous videos?

[@AsliEngineering]

That exactly was the intention :) I have not yet covered the Query Execution Plan, but I do have plans of covering it. Thanks for the nudge.

[@rishabhthakur2028]

I always find the compiler design the worst topic but the way you explain the things made me fall in love with the subject or topic.

[@beest_]

The build process was explained backwards.

[@architectingme]

Arpit, which device and software are you using to teach? It would be helpful if you share the info

[@AsliEngineering]

iPad + GoodNotes app with my custom theme.

[@gauravpant4768]

Very useful, thank you