You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/11/14 01:42:47 UTC

[GitHub] [age] JoshInnis opened a new issue, #354: AGE Onboarding - Learn Postgres Basics 2

JoshInnis opened a new issue, #354:
URL: https://github.com/apache/age/issues/354

   Read Chapter 1-3: https://www.interdb.jp/


-- 
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.apache.org

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


[GitHub] [age] Zahid07 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
Zahid07 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1343958773

   Started the Chapter 1


-- 
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


[GitHub] [age] abdulmanann commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
abdulmanann commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377619210

   Hello!
   Excited to learn about hacking Postgres!


-- 
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


[GitHub] [age] fatimafatimaprogrammer commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
fatimafatimaprogrammer commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1345481227

   Completed reading first 2 chapters of "Internals of PostgreSQL" and published small articles on my linkdin account Links are attached here 
   **Chapter #1:**
   https://www.linkedin.com/posts/urooj-fatima-raza_data-database-postgresql-activity-7005488657067323392-fls9?utm_source=share&utm_medium=member_desktop
   **Chapter #2:**
   https://www.linkedin.com/pulse/internals-postgresql-chapter2-urooj-fatima-raza


-- 
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


[GitHub] [age] JawadAliAbbasi commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
JawadAliAbbasi commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377618455

   Hi all


-- 
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


[GitHub] [age] abdullahzia-6464 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "abdullahzia-6464 (via GitHub)" <gi...@apache.org>.
abdullahzia-6464 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1510759146

   Excited to learn more about Postgres!


-- 
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


[GitHub] [age] salarabbasi01 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "salarabbasi01 (via GitHub)" <gi...@apache.org>.
salarabbasi01 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1513421564

   Hello everyone
   Happy to be a part of this community


-- 
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


[GitHub] [age] panosfol commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "panosfol (via GitHub)" <gi...@apache.org>.
panosfol commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1437591233

   _Here is a summary of the first 3 chapters of the Internals of PostgreSQL:_
   
   
   **Chapter 1** introduces the logical structure of the database clusters each with their own collection of databases and database objects and then focuses on the physical structure of how the base directory and the subdirectories work with each other. Also it analyzes the internal layout of a data file, focusing on the heap table file. Lastly it mentions the methods of writing and reading heap tuples.
   
   **Chapter 2** focuses on the processes that run on a PostgreSQL server especially on the server process, the backend processes and the background processes. Also it discusses the memory architecture in PostgreSQL dividing into to areas, the local memory area, allocated by each backend process for its own use, and the shared memory area, used by all processes of a PostgreSQL server.
   
   **Chapter 3** delves deeper into a more complex subsystem of the PostgreSQL, the query processing and especially the query optimization. This chapter focuses around the 5 subsystems: the parser, the analyzer, the rewriter, the planner and the executor and how each system contributes to the execution of a given query. Then it focuses on the cost estimation of a single-table query and how does the planner calculates and creates the plan tree. After that it analyzes the executor and the join operations, focusing on the nested loop join, the merge join and the hash join. The chapter closes with an explanation of a plan tree of a multiple-table query.


-- 
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


[GitHub] [age] dukeofhazardz commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "dukeofhazardz (via GitHub)" <gi...@apache.org>.
dukeofhazardz commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1500500769

   This is a summary of the first chapter of the book 'Internals of PostgreSQL'
   
   The first chapter of 'The Internals of PostgreSQL' covers the logical and physical structures of a database cluster, including the definition of a database cluster, a collection of databases managed by a PostgreSQL server.
   
   The chapter describes the relationship between databases and database objects, which are data structures used to store or reference data, and the use of object identifiers (OIDs) to manage these objects and how to find the OIDs of databases and heap tables by querying system catalogs such as pg_database and pg_class.
   
   The chapter also describes the physical structure of a PostgreSQL database cluster. The database cluster is a directory referred to as the "base directory" that contains many subdirectories and files. The database cluster is created using the initdb utility and is typically located in the PGDATA environment variable. Each database in the cluster is a subdirectory under the "base" subdirectory, and tables and indexes are stored as files under the database subdirectory. PostgreSQL also supports tablespaces, which are directories that contain data outside of the base directory.
   
   The chapter describes the layout of databases and files associated with tables and indexes in a PostgreSQL database cluster. Each database has a subdirectory named after its respective OID under the base subdirectory. Tables and indexes smaller than 1GB are stored as a single file under the database directory they belong to. These data files are managed by the relfilenode variable, and their values basically match their respective OIDs. However, the relfilenode values can be changed using commands like TRUNCATE, REINDEX, and CLUSTER. For example, if a table is truncated, a new relfilenode is assigned, the old data file is removed, and a new one is created.
   
   The chapter covers the layout of files associated with tables and indexes in a PostgreSQL database cluster. Each table or index is a single file stored under the database directory it belongs to, and the filenames are identified by the respective OIDs. The tables have two associated files, the free space map and the visibility map, which store information on the free space capacity and the visibility on each page within the table file, respectively. Indexes only have individual free space maps and do not have a visibility map. These files may be internally referred to as the forks of each relation. PostgreSQL also allows the creation of tablespaces, which are additional data areas outside the base directory, and the version-specific subdirectory will be created under the directory specified in the CREATE TABLESPACE statement.
   
   The data file in PostgreSQL is divided into pages or blocks of fixed length. The pages are numbered sequentially from 0 and have block numbers. The internal layout of the pages consists of heap tuples, line pointers, and header data. The header data contains general information about the page such as pd_lsn, pd_checksum, pd_lower, pd_upper, and pd_special. To identify a tuple, tuple identifier (TID) is used, which comprises a pair of values: the block number of the page that contains the tuple and the offset number of the line pointer that points to the tuple. Heap tuples whose size is greater than about 2 KB are managed using the TOAST technique.
   
   The chapter concludes by discussing the methods of writing and reading heap tuples. When inserting a new tuple, a new line pointer is added to the page and the pd_lower and pd_upper pointers are updated accordingly. Sequential scan involves reading all tuples in all pages by scanning all line pointers in each page, while B-tree index scan involves reading index tuples containing index keys and TIDs pointing to the target heap tuple, which can then be directly read without unnecessary scanning in the pages.


-- 
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


[GitHub] [age] waleedahmed0001 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
waleedahmed0001 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377626172

   Hi guyss...
   
   Excited to learn about postgres.


-- 
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


[GitHub] [age] Ammar-Baig19 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "Ammar-Baig19 (via GitHub)" <gi...@apache.org>.
Ammar-Baig19 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1596238829

   Learning Postgres is a great opportunity. Started learning Chapter 1-3. Will share summaries about my learning soon.


-- 
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


[GitHub] [age] dukeofhazardz commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "dukeofhazardz (via GitHub)" <gi...@apache.org>.
dukeofhazardz commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1500698692

   Summary of the second chapter of the book 'Internals of PostgreSQL'
   
   The second chapter of the book 'The Internals of PostgreSQL' provides a summary of the process architecture and memory architecture in PostgreSQL to help readers understand the subsequent chapters.
   
   PostgreSQL is a client/server type RDBMS with a multi-process architecture that runs on a single host. The PostgreSQL server comprises of various processes, including postgres server processes, backend processes, background processes, replication-associated processes, and background worker processes. 


-- 
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


[GitHub] [age] TalhaMunir-JD commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
TalhaMunir-JD commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377625323

   Hi guyss...
   
   Excited to learn about postgres.


-- 
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


[GitHub] [age] dukeofhazardz commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "dukeofhazardz (via GitHub)" <gi...@apache.org>.
dukeofhazardz commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1507596405

   Summary of the third chapter of the book 'Internals of PostgreSQL'
   
   The third chapter of 'The Internals of PostgreSQL' covers the query processing in PostgreSQL.
   
   The chapter overviews the five subsystems of the backend which handles all queries issued by the connected client, and they are;
   The parser which generates a parse tree from an SQL statement in plain text. The analyzer which carries out a semantic analysis of a parse tree and generates a query tree. The rewriter which transforms a query tree using the rules stored in the rule system if such rules exist. The planner which generates the plan tree which can be executed effectively from the query tree. and lastly, the executor which executes the query via accessing the tables and indexes in the order that was created by the plan tree.
   Furthermore the chapter also touches on the cost estimation in single query, which includes the start up, run and total costs. And also the sequential and index scans and the respective formulas used to estimate their start up, run, and total costs.
   Finally, the join operations in postgresql with their different cost estimations and the Plan Tree of Single and Multiple-Table Queries, which has to do with the planner getting the cheapest access path and estimating the costs of all possible access paths and choices, and then choosing cheapest one


-- 
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


[GitHub] [age] Jahangirbabar2000 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "Jahangirbabar2000 (via GitHub)" <gi...@apache.org>.
Jahangirbabar2000 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1556294403

   Hi Everyone! Excited to learn and work on Postgres!


-- 
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


[GitHub] [age] fahadullah-112 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "fahadullah-112 (via GitHub)" <gi...@apache.org>.
fahadullah-112 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1599622183

   I have started learning Postgres and it is a great opportunity. Started learning Chapter 1-3. I will share my learning and views on what I've learnt. Best of luck guys


-- 
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


[GitHub] [age] AhmedMo0 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "AhmedMo0 (via GitHub)" <gi...@apache.org>.
AhmedMo0 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1502389341

   Summary of the first 3 chapters in 'Internals of PostgreSQL' book
   
   chapter 1:
   https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-1-in-the-internals-of-postgresql-book-fl5
   
   chapter 2:
   https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-2-in-the-internals-of-postgresql-book-img
   
   chapter 3:
   https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-3-in-the-internals-of-postgresql-book-1ap0


-- 
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


[GitHub] [age] abduu11aahh commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
abduu11aahh commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377619398

   Hi guys!!
   
   Excited to work and learn  from all of you !


-- 
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


[GitHub] [age] moiz697 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by GitBox <gi...@apache.org>.
moiz697 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1377621140

   hey! excited to work with You  guys.


-- 
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


[GitHub] [age] hammadsaleemm commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "hammadsaleemm (via GitHub)" <gi...@apache.org>.
hammadsaleemm commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1441133322

   Competed first chapter, see post about the review on LinkedIn as well.
   
   https://www.linkedin.com/posts/hammad-saleem-4313a81a4_postgresql-database-cluster-databases-and-activity-7032612286489858048-qJ7b?utm_source=share&utm_medium=member_android
   


-- 
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


[GitHub] [age] MuhammadZeeshan03 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "MuhammadZeeshan03 (via GitHub)" <gi...@apache.org>.
MuhammadZeeshan03 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1509619638

   Hi guys,
   
   Excited to learn about postgres.


-- 
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


[GitHub] [age] Muzzammil242 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "Muzzammil242 (via GitHub)" <gi...@apache.org>.
Muzzammil242 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1510464482

   Hi guys!
   
   Excited to work with you all!


-- 
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


[GitHub] [age] Hannan2910 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "Hannan2910 (via GitHub)" <gi...@apache.org>.
Hannan2910 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1510694916

   Hi guys!
   
   Hoping for a good experience learning postgres


-- 
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


[GitHub] [age] ahmadtash7 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "ahmadtash7 (via GitHub)" <gi...@apache.org>.
ahmadtash7 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1519053204

   ### Summary of Chapters 1 - 3 of The Internals of PostgreSQL
   
   _**Ch - 1: Database Cluster, Databases, and Table**_
   
   Logical structures of database clusters are explained by defining database clusters and how all database objects are managed by OIDs.
   
   Physical structure of database clusters are explained by illustrating the base directory that includes subdirectories and files, including the base. Furthermore, the layouts of database cluster, database, and files associated with tables and indexes and Tablespaces are explained.
   
   Then, the internal layout of a heap table file - divided into pages (or blocks) - is mentioned. The pages inside the heap table file may contain head tuple, line pointer, or header data.
   
   Finally, methods of writing and reading tuples (sequential and B-tree index scans) are talked about.
   
   **_Ch- 2: Process and Memory Architecture_**
   
   PostgreSQL is a client/server type relational database management system with multiprocess architecture. Its types _postgres server process_, _backend process_, _background processes_, _replication associated processes_, and _background worker process_ are all highlighted and explained.
   
   Then, the reader’s focus is diverted to memory architecture - _local_ and _shared memory areas_.
   
   _**Ch - 3: Query Processing**_
   
   A backend process handles all queries issued by the connected client. There are five subsystems in this background process, namely; parser, analyser, rewriter, planner, and executor. All their roles have been defined here and visualised with diagrams.
   
   Then, cost estimation in single-table query is done. Three types of costs start-up, run, and total are introduced. To retrieve data from the tables, scans are employed in postgreSQL. Each scan has their own costs. Scans include sequential and index scans. 
   
   We then have the Sort, used for sorting operations like merge etc. Then, we learn to create the plan tree of a single table query. We first preprocess try to figure out the cheapest access path and then, create a plan tree. 
   
   We see how the executor performs using the EXPLAIN command and reading the output.
   
   PostgreSQL has a number of Join operations that have further variations: nested loop join, materialised loop join, merge join, and hash join.- join access paths and join nodes. Each Join has a JoinPath structure.
   
   A plan tree for multiple-table query can also be made using the same steps as mentioned priorly to make a plan tree for a single-table query.


-- 
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


[GitHub] [age] RahimullahShaheen commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

Posted by "RahimullahShaheen (via GitHub)" <gi...@apache.org>.
RahimullahShaheen commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1523413491

   **Here is a summary of the first 3 chapters of "The Internals of PostgreSQL"**
   
   - Chap-1: Database Cluster, Databases, and Table
   
   The first chapter gives us overview about the logical and physical structures of a postgresql database cluster.
   
   The logical structure of a database cluster consists of databases, which are collections of database objects which are internally managed by respective object identifiers (OIDs) and is stored in system catalogs. The physical structure of database cluster is also described, with each database being a subdirectory under the base directory and in the subdirectories there are other files containing particular data and configuration file.
   
   The chapter also gives us information about layout of databases and files associated with tables and indexes in a postgresql database cluster and about tablespace. Tablespaces are additional data area outside the base directory to store data.
   
   The internal layout of Heap Table file is explained later in the chapter, which is data file divided into pages of fixed length which are numbered sequentially from 0 and these numbers are called as block numbers.
   Finally this chapter explains about the methods of writing and reading tuples which are record data and are stacked in order from the bottom of the page within a heap table file.
   
   - Chap-2: Process and Memory Architecture
   
   The second chapter discusses about the process and memory architecture. 
   A postgresql server contains multiple types of processes to manage database cluster which are as follow.
   The server process which is the parent of all processes is responsible for starting various background processes and backend processes.
   
   The backend process which is also known as postgres is used for handling queries issued by connected clients.
   
   The background process is used for performing various task related to database management like checkpoints, background writer etc.
   
   Finally the chapter explains about the Memory architecture. It is classified into 2 types, the local memory area is allocated by each backend processes for querying process and is further divided into several sub-areas whose sizes are either fixed or variable. The shared memory is allocated by the postgresql server which is also divided in to several fixed size sub-areas.
   
   - Chap-3: Query Processing
   
   The third chapter explains how queries issued by the connected client are handled by the backend process.
   
   The backend process consists of five subsystems which are discussed below.
   
   When a query is send to postgres first thing it does is to convert it into a structure known as parser tree that is more easier for other components to understand and it is done by the parser.
   The analyzer then figures out what the query is trying to do. The optimizer optimizes the query the best it can and based on the given query postgres might be capable to execute the query in multiple ways and the planner chooses the best way for the execution from the available ways. Then finally when the above steps are done the query is executed.
   Further more the chapter discuses the cost estimation of a single query which includes sort, startup and cost run.
   
   Finally, the 3 join methods supported by the postgresql which are nested loop, merge and has join, are slighted explained.
    
   


-- 
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