Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 71C56B5D8BD for ; Mon, 23 May 2011 11:28:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 27223-06 for ; Mon, 23 May 2011 14:28:10 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 5C158B5D801 for ; Mon, 23 May 2011 11:28:10 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id p4NESATO006037 for ; Mon, 23 May 2011 11:28:10 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id p4NERrEs001620 for pgsql-admin@postgresql.org; Mon, 23 May 2011 11:27:53 -0300 (ADT) (envelope-from news) From: jtkells@verizon.net X-Newsgroups: pgsql.admin Subject: WAL and Checkpoints documentation Message-ID: X-Newsreader: Forte Agent 6.00/32.1186 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 8 X-Complaints-To: abuse@easynews.com Organization: Forte Inc. http://www.forteinc.com/apn/ X-Complaints-Info: Please be sure to forward a copy of ALL headers otherwise we will be unable to process your complaint properly. Date: Mon, 23 May 2011 10:27:48 -0400 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/154 X-Sequence-Number: 37591 I have been reading the POSTGRESQL System Admin Documentation 8.4 (several times) on WAL and Checkpoints along with their respected option switches. I can say that I have a general understanding of what is going on but get confused with the details and use of the option switches. Does anyone know of any good presentations/whitepapers that spell out WAL and check-pointing functionality other than the ADMIN guide? Thanking you in advance