Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 228259FB22E for ; Mon, 28 May 2007 13:32:00 -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 80657-01 for ; Mon, 28 May 2007 13:31:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 3CE479FB249 for ; Mon, 28 May 2007 13:31:54 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so937401uge for ; Mon, 28 May 2007 09:31:54 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=ifLGpwlpe3yiIiq9cNxLVCIskn+KASEltjmeFCsCg41y2kK1hieP3bHBwZcrrHpDnud/DDAYhRAS0y20DZvBhe3tSCN3K5JVRLVpx16dj2lRpHr8gJTaR2Pmt5IrjnGvBjJbzKhhU+VyRoYlhx1xJjQ4YOPwc7c0gBDjnYoS5co= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=f9cr1gAAtnknxUc6p0VlB8ZGzoATpF2wroYX9UBV/i2MxP2h7V3CsTnaePL3zl+OAl3mRZ+vDD1PwBI3VtFQ1mhgVyjDZ4ii+IEAOj6TgYY/e/N/f1mnRysNksLWkgctdilJpqLIqTf/0i/706d8NxdWsCPsVL03kiWA5gmYriY= Received: by 10.67.97.18 with SMTP id z18mr5359007ugl.1180369913958; Mon, 28 May 2007 09:31:53 -0700 (PDT) Received: from ?192.168.0.199? ( [80.222.48.97]) by mx.google.com with ESMTP id 55sm13315979ugq.2007.05.28.09.31.49; Mon, 28 May 2007 09:31:52 -0700 (PDT) Message-ID: <465B03E5.1000109@enterprisedb.com> Date: Mon, 28 May 2007 17:31:33 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Dave Cramer CC: postgresql performance list Subject: Re: PITR performance costs References: <81165B3E-1099-4388-88F1-FA27A3AD92BC@fastcrypt.com> In-Reply-To: <81165B3E-1099-4388-88F1-FA27A3AD92BC@fastcrypt.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/573 X-Sequence-Number: 24963 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