intrigued-rishi commented on issue #355: URL: https://github.com/apache/age/issues/355#issuecomment-1336345580
Chapter 1: Learnt about how the Database cluster works in PostgreSQL and also how the server manages the flow of the cluster. Then went through the internal physical structure of the database cluster and how the base directory, database objects, files, indexes are organised in a hierarchical manner. Also studied about the internal layout of the Heap table file and how pages and tuples are organised. Chapter 2: Learnt about the Process and Memory architecture of PostgreSQL. The Postgres server process, the various backend and worker processes consist of the main few processes in Postgres. Also studied about the various local and shared memory present in Postgres Chapter 3: Learnt about the various steps of Query processing about how a simple query is parsed, analysed and taken for execution. Discovered how a plan tree is constructed to represent the flow of action. Also looked into how cost estimation is made for the different scans like sequential, index scan etc. and also for the different JOIN operations. -- 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]
