Re: On How To Shorten the Steep Learning Curve Towards PGHacking... - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: On How To Shorten the Steep Learning Curve Towards PGHacking...
Date
Msg-id 0A3221C70F24FB45833433255569204D1F6BC430@G01JPEXMBYT05
Whole thread Raw
In response to On How To Shorten the Steep Learning Curve Towards PG Hacking...  (Kang Yuzhe <tiggreen87@gmail.com>)
Responses Re: On How To Shorten the Steep Learning Curve Towards PG Hacking...
List pgsql-hackers
From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Kang Yuzhe

> 1. Prepare Hands-on with PG internals
> 
> 
>  For example, a complete Hands-on  with SELECT/INSERT SQL Standard PG
> internals. The point is the experts can pick one fairly complex feature
> and walk it from Parser to Executor in a hands-on manner explaining step
> by step every technical detail.

I sympathize with you.  What level of detail do you have in mind?  The query processing framework is described in the
manual:

Chapter 50. Overview of PostgreSQL Internals
https://www.postgresql.org/docs/devel/static/overview.html

More detailed source code analysis is provided for very old PostgreSQL 7.4, but I guess it's not much different now.
Thedocument is in Japanese only: 
 

http://ikubo.x0.com/PostgreSQL/pg_source.htm

Are you thinking of something like this?

MySQL Internals Manual
https://dev.mysql.com/doc/internals/en/





Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)
Next
From: Pavan Deolasee
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)