Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 994FB9FB30D for ; Mon, 28 May 2007 15:49:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 15069-01 for ; Mon, 28 May 2007 15:49:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id D58699FB21D for ; Mon, 28 May 2007 15:49:00 -0300 (ADT) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id CCBB9158067F; Mon, 28 May 2007 14:57:54 -0400 (EDT) In-Reply-To: <465B03E5.1000109@enterprisedb.com> References: <81165B3E-1099-4388-88F1-FA27A3AD92BC@fastcrypt.com> <465B03E5.1000109@enterprisedb.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: postgresql performance list Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: PITR performance costs Date: Mon, 28 May 2007 14:48:55 -0400 To: Heikki Linnakangas X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/574 X-Sequence-Number: 24964 Heikki, Don't the archived logs have to be copied as well as the regular WAL logs get recycled ? Dave On 28-May-07, at 12:31 PM, Heikki Linnakangas wrote: > Dave Cramer wrote: >> Since PITR has to enable archiving does this not increase the >> amount of disk I/O required ? > > There's no difference in normal DML operations, but some bulk > operations like CREATE INDEX that don't otherwise generate WAL, > need to be WAL logged when archiving is enabled. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com