Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5210E6324EC for ; Mon, 5 Apr 2010 10:54:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19515-03 for ; Mon, 5 Apr 2010 13:54:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sn.sai.msu.ru (sn.sai.msu.ru [195.208.220.215]) by mail.postgresql.org (Postfix) with ESMTP id 8E7146321A8 for ; Mon, 5 Apr 2010 10:54:07 -0300 (ADT) Received: from sn.sai.msu.ru (localhost [127.0.0.1]) by sn.sai.msu.ru (8.14.1/8.12.8) with ESMTP id o35DruNW009463; Mon, 5 Apr 2010 17:53:56 +0400 Received: from localhost (megera@localhost) by sn.sai.msu.ru (8.14.1/8.12.8/Submit) with ESMTP id o35Drt8X009460; Mon, 5 Apr 2010 17:53:55 +0400 X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs Date: Mon, 5 Apr 2010 17:53:55 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@sn.sai.msu.ru To: Rafael Martinez cc: pgsql-docs@postgresql.org Subject: Re: Documentation and explanatory diagrams In-Reply-To: <4BB9E69F.9080203@usit.uio.no> Message-ID: References: <4BB9E69F.9080203@usit.uio.no> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/29 X-Sequence-Number: 5428 That would be very nice to have ! Oleg On Mon, 5 Apr 2010, Rafael Martinez wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello > > I am wondering if we have ever evaluated the use of explanatory diagrams > in the PostgreSQL documentation. > > I have always thought that a good diagram is worth a thousand words. I > think the PostgreSQL manual would improve its quality if we get some > good diagrams on the right places. > > They will help novice and advanced users who are not involved in the > development of PostgreSQL, to get a quick overview of some central > components in a PostgreSQL system when they read the documentation. > > Some of the possible diagrams that come to my mind in none particular > order are: > > - PITR > - Streaming Replication > - Hot Standby > - Write-Ahead Log > - System Catalogs > - Architectural Fundamentals overview > - PostgreSQL server overview > - Disk layout > - Database Roles and Privileges > - Database Physical Storage > - Security and authentication > > What do you think about the idea? I could start working on an initial > version of some of these diagrams if you are interested in the idea. > > regards, > - -- > Rafael Martinez, > Center for Information Technology Services > University of Oslo, Norway > > PGP Public Key: http://folk.uio.no/rafael/ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAku55ocACgkQBhuKQurGihRbJQCfVA9SYVWkyfudFg7XPDlLXYeV > tKAAmgMjg1tfU63sf0RTMRoFTtfsn/Pj > =2+9o > -----END PGP SIGNATURE----- > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83