Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7EE4A6327D1 for ; Mon, 5 Apr 2010 10:31:33 -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 15943-09 for ; Mon, 5 Apr 2010 13:31:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-out2.uio.no (mail-out2.uio.no [129.240.10.58]) by mail.postgresql.org (Postfix) with ESMTP id BEEBD6322FA for ; Mon, 5 Apr 2010 10:31:22 -0300 (ADT) Received: from mail-mx3.uio.no ([129.240.10.44]) by mail-out2.uio.no with esmtp (Exim 4.69) (envelope-from ) id 1NymOe-0003up-IR for pgsql-docs@postgresql.org; Mon, 05 Apr 2010 15:31:20 +0200 Received: from ti0153a380-2121.bb.online.no ([83.108.27.77] helo=[10.1.1.200]) by mail-mx3.uio.no with esmtpsa (TLSv1:AES256-SHA:256) user rafael (Exim 4.69) (envelope-from ) id 1NymOe-0002X0-3J for pgsql-docs@postgresql.org; Mon, 05 Apr 2010 15:31:20 +0200 Message-ID: <4BB9E69F.9080203@usit.uio.no> Date: Mon, 05 Apr 2010 15:33:19 +0200 From: Rafael Martinez User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Documentation and explanatory diagrams X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-UiO-Ratelimit-Test: rcpts/h 1 msgs/h 1 sum rcpts/h 1 sum msgs/h 1 total rcpts 2047 max rcpts/h 14 ratelimit 0 X-UiO-Spam-info: not spam, SpamAssassin (score=-8.0, required=5.0, autolearn=disabled, UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO) X-UiO-Scanned: C7DF93283459A27D8F6210211BFF47F861C31EBD X-UiO-SPAM-Test: remote_host: 83.108.27.77 spam_score: -79 maxlevel 80 minaction 2 bait 0 mail/h: 1 total 2 max/h 1 blacklist 0 greylist 0 ratelimit 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201004/28 X-Sequence-Number: 5427 -----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-----