[GitHub] [age] MuhammadTahaNaveed commented on issue #355: AGE Onboarding - Learn Postgres Basics Group 1

[GitBox <gi...@apache.org>]

MuhammadTahaNaveed commented on issue #355:
URL: https://github.com/apache/age/issues/355#issuecomment-1334114895

   `Chapter 1` explained about the structure of database cluster(both physically and logically using OIDs), different files in database cluster and their description, layout of heap table file(where the actual table rows are stored),methods of reading heap tuples(seq scan and B-Tree index scan) and writing tuples into heap table. `Chapter 2` explained about the processes(postgres server process and its child processes  which can be either backend or background process), how processes allocate a local memory area and use Shared-memory area. `Chapter 3` explained about the five subsystems(parser, analyzer, rewriter, planner and executor) of the backend process(which handles queries), cost estimation of methods of reading heap tuples(seq scan and index scan) and lastly working of different join methods.


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org