Received: from maia.hub.org (unknown [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 66FEF1337B5C for ; Thu, 21 Oct 2010 12:45:26 -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 05770-10 for ; Thu, 21 Oct 2010 15:45:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8]) by mail.postgresql.org (Postfix) with ESMTP id 86BC6133655C for ; Thu, 21 Oct 2010 12:45:17 -0300 (ADT) Received: from [192.168.1.7] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0LwG3q-1OZH9y2NRe-017W0n; Thu, 21 Oct 2010 17:45:13 +0200 Message-ID: <4CC06007.3090003@2ndquadrant.com> Date: Thu, 21 Oct 2010 11:45:11 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Brad Nicholson CC: pgsql-performance@postgresql.org Subject: Re: New wiki page on write reliability References: <4CC04945.7030100@2ndquadrant.com> <4CC04F89.6020503@ca.afilias.info> In-Reply-To: <4CC04F89.6020503@ca.afilias.info> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:ZeGyNj3s45vJivSU71xM7zmUm1pJxbDtTpWQfibcda4 Mx5l5dTWtE4nMPFANTesuuXkRonqOtTsbVab2uZ4pPhelnA1Za lninrY88eJEOV9qLWN1wZ86dkjIRXfd9o/dXDginnrXXEsRdw/ 3s1THzjpV9pmsz3xHkdCJMvM0sS3HLM4UQ7wikkQ2f02sWPC7l ZPoqkc4CKsmESIYKsHIkyCts28Q9iqmJ/tfBHKdydU= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/348 X-Sequence-Number: 40766 Brad Nicholson wrote: > I think a warning turning fsync off, the dangers of async_commit, and > the potential problems with disabling full_page_writes might be worth > mentioning on this page, unless you want to leave that buried in the > attached references. Good idea to highlight that. What I just did here was point out which of the references covered that specific topic, which is as good as I could do for now. It's hard for me to justify spending time writing more about those when they are covered in the attached references, and I personally can't do it because of my publishing agreement. The fact that the information about this topic is what ended up being released as the sample material from my book is not coincidence--I wanted to be able to share what I'd done here as a free community resources because this topic is so important to me. But I can't go much further than what I've already put up there myself. -- Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us