Additional Chapter for Tutorial
Jürgen Purtz <juergen@purtz.de>
From: Jürgen Purtz <juergen@purtz.de>
To: Pg Docs <pgsql-docs@lists.postgresql.org>
Date: 2020-04-17T17:56:08Z
Lists: pgsql-hackers, pgsql-docs
Attachments
- 0001-architecture.patch (text/x-patch) patch 0001
Our documentation explains many details about commands, tools, parameters in detail and with high accuracy. Nevertheless my impression is that we neglect the 'big picture': why certain processes exist and what their relation to each other is, summary of strategies, visualization of key situations, ... . People with mature knowledge don't miss this information because they know all about it. But for beginners such explanations would be a great help. In the time before GSoD 2019 we had similar discussions. I plan to extend over time the part 'Tutorial' by an additional chapter with an overview about key design decisions and basic features. The typical audience should consist of persons with limited pre-knowledge in database systems and some interest in PostgreSQL. In the attachment you find a patch for the first sub-chapter. Subsequent sub-chapters should be: MVCC, transactions, VACUUM, backup, replication, ... - mostly with the focus on the PostgreSQL implementation and not on generic topics like b-trees. There is a predecessor of this patch: https://www.postgresql.org/message-id/974e09b8-edf5-f38f-2fb5-a5875782ffc9%40purtz.de . In the meanwhile its glossary-part is separated and commited. The new patch contains two elements: textual descriptions and 4 figures. My opinion concerning figures is set out in detail in the previous patch. Kind regards, Jürgen Purtz
Commits
-
Align some terms in arch-dev.sgml to glossary
- 6734e806958c 14.0 landed
-
doc: Copy-edit the "Overview of PostgreSQL Internals" chapter
- 29ad6595ef7f 14.0 landed
-
Merge postmaster and postgres command into just postgres. postmaster
- 5266f221a2e1 8.2.0 cited