GhostVaibhav commented on issue #355: URL: https://github.com/apache/age/issues/355#issuecomment-1333868315
@abdinabi123 Surely, I learned about the **logical and physical structure of a database cluster**, whilst also learning about the **heap table file** and the **methods for reading and writing** in that. In the second chapter, I learned about the **process architecture** in a Postgres database while also shedding light on the various **backend processes** (_the server process, backend process, worker process, etc._). In addition to that, I also learned about the **memory architecture** of Postgres (_local and shared_). In the third chapter, I broadly learned about **query processing** which further bifurcates into **five subsystems** (_namely parser, analyzer, rewriter, planner, and executor_) with a brief introduction to all. I also learned about the **cost estimation of a query** (_in particular of the sequential scan, sort, and index scan_). I also learned about the **creation of a plan tree**, the **role of the executor**, and the **various join operations** (_merge join, neste d loop join, and hash join_). The third chapter was a bit intensive in terms of the keywords as well as the concepts involved (_I couldn't understand it fully😅_). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
