Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 8AF932E0032 for ; Mon, 5 May 2008 12:54:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 75070-01 for ; Mon, 5 May 2008 12:54:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by developer.postgresql.org (Postfix) with ESMTP id DA2412E009A for ; Mon, 5 May 2008 12:54:16 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 76so1310695wra.10 for ; Mon, 05 May 2008 08:54:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=oWISVFGiOqROsKnuc4j2qMkHv5cu1xJo/IHgEN6iZEY=; b=uTsFx1Z95H59MuUFxCTfIS1i99uToQPRWyw8is4fLfAf/oMSs+IFkIiyWFUO/FqZHj4jiiyxQO4RosotgJz3J6dFB0kH2qJ5iFOAWAzbetrMmYDRpT2TcM2GiXnJhq5DW66YFgmxel21kKTUKewALZ4IYL/eRZITQ+yfaSXLNmw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GiiLIjmCrGY/sASSPWmyF6ndVpSOK8K5XQhrRQZvP8L735xC6PmzeOZueXSn9dww9W3WB9X3pBIQUxETtXVFT3ZyE2+Ty8RMuFoiRBSIOpOpZHhPKBS1rqZipQUoaUB/KXo5keQo3msbTDgz2Gbjpp1UaBEqCNvu1c+etK2opuQ= Received: by 10.114.36.1 with SMTP id j1mr5843249waj.119.1210002855522; Mon, 05 May 2008 08:54:15 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Mon, 5 May 2008 08:54:15 -0700 (PDT) Message-ID: Date: Mon, 5 May 2008 09:54:15 -0600 From: "Scott Marlowe" To: "Campbell, Lance" Subject: Re: Backup causing poor performance - suggestions Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/54 X-Sequence-Number: 30022 On Mon, May 5, 2008 at 9:10 AM, Campbell, Lance wrote: > Scott, > The server is a Dell PowerEdge 2900 II with the standard Perc 6/I SAS > controller with 256 MB cache. It's probably not gonna win any awards, but it's not too terrible. What does vmstat 1 say during your backups / normal operation? The last four or five columns have the most useful data for troubleshooting.