Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A82EC641E21 for ; Mon, 15 Mar 2010 06:57:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 74224-07 for ; Mon, 15 Mar 2010 09:57:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136037.authsmtp.co.uk (outmail136037.authsmtp.co.uk [62.13.136.37]) by mail.postgresql.org (Postfix) with ESMTP id DDE8A641E1D for ; Mon, 15 Mar 2010 06:57:36 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2F9v5eQ096744; Mon, 15 Mar 2010 09:57:05 GMT Received: from [192.168.0.4] (88-110-151-22.dynamic.dsl.as9105.com [88.110.151.22]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2F9v2PQ064038; Mon, 15 Mar 2010 09:57:02 GMT Subject: Re: Off-site storage for PITR logs From: Simon Riggs To: Nicos Panayides Cc: pgsql-admin@postgresql.org In-Reply-To: <4B9DFD67.3050106@magneta.com.cy> References: <4B9A6E8B.4050303@magneta.com.cy> <1268556612.3825.5025.camel@ebony> <4B9DFD67.3050106@magneta.com.cy> Content-Type: text/plain Date: Mon, 15 Mar 2010 09:57:01 +0000 Message-Id: <1268647021.3825.7469.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: 1adb095e-3019-11df-80b9-0022640b883e X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaQBbYFhD HGQLWlREUFR7XGR/ awgfZQ1DY0tOQQRv UVZLQE1XHAJ3AVJe BGgXFBsSFgVAfH5z bQhjWHVfEkUrIRR9 S0sBCG4GZG59aWFL Bl1Qd1FdbQNKfB1D blAtXHsONCtlM3Bw LCYfGhEXCH14JioQ WQARIBoJXUERFzEx Dx4FB30XPHE/DyE0 IAdO X-Authentic-SMTP: 61633235383639.1015:706/Kp X-AuthFastPath: 255 X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.411 tagged_above=-10 required=5 tests=AWL=0.188, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/94 X-Sequence-Number: 33893 On Mon, 2010-03-15 at 11:27 +0200, Nicos Panayides wrote: > thanks for the suggestion. What kind of space savings should I expected > from turning off full_page_writes? Substantial, though you should measure it and see, since it is workload dependent. -- Simon Riggs www.2ndQuadrant.com