RC-002 commented on issue #355:
URL: https://github.com/apache/age/issues/355#issuecomment-1342593457
Summary of what I learnt from the first 3 chapters of "The Internals of
PostgreSQL"
Chapter 1:
This was the first time I heard that there was a Database cluter. I learnt
what it is, it's logical and physical structure. I learnt about the various
configuration files in the cluster. Tablespaces was an interesting concept and
I learnt more about it from the official PostgreSQL docs. The addressing and
the directory structure of files and pages was new and rather intuitive.
Finally, I learnt about the heap table file and the 2 methods of writing and
reading them.
Chapter 2:
I learnt about the process architecture of PostgreSQL. Acuum process was new
to me and I learnt about it from the official docs. I read about the vaarious
processes involved. Finally, I went through the memory architecture and the
buffers invloved.
Chapter 3:
I learnt about the parser and generation of parse trees. The analyzer was
new and I read about parsenodes.h and its contents. The logic behind the
planner and executor working was not very intuitive for me and I have a
newfound appreciation for the same. The three costs - start-up, run and total,
cost_seqscan and cost_index functions, random page costs and indexes. I then
learnt about the plan tree and the steps involved in its creation. I already
knew the join operations but I was able to learn the einternals of how they
work. Finally, I read about the parse tree for multi-table queries and how to
find the cheapest path.
--
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]
