How to learn Postgresql and its internals?

Question

I am green on postgresql, so when reading source code of pg, I am very confused....Is there some useful material on postgresql source code? Thank you.

Answer 1

There are some nice presentations about some basic concepts like Datum, V1 Functions Calls and source code

http://www.postgresql.org/developer/coding http://www.postgresql.org/files/developer/internalpics.pdf

this master thesis is very good document http://www.ic.unicamp.br/~celio/livrobd/postgres/ansi_sql_implementation_postgresql.pdf

http://www.postgresql.org/developer/ext.backend_dirs.html

Answer 2

It seems you are also unversed in using the internet!? ;-) First look should be the project homepage http://www.postgresql.org/. There you will find a "Developers" link which directs you to the available resources. One of them is the Developer FAQ which should be more than sufficient for the beginning.

Answer 3

Seems very usefull book - The Internals of PostgreSQL