Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A28CB9F9EF4 for ; Wed, 22 Aug 2007 13:28: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 07395-04 for ; Wed, 22 Aug 2007 13:28:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by postgresql.org (Postfix) with ESMTP id 4FFF19F97AF for ; Wed, 22 Aug 2007 13:28:01 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id c24so150707rvf for ; Wed, 22 Aug 2007 09:28:00 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=GaBeEzaeSni1iFsIcP+ll7HTsExwprZ4lwcu3TrLOOEszVcomD3kNEE7xcDAODGid3dLkEehhbvsVbshJ5GHTCINmgJCkLDgRZRDrUZT7eCzN2A2zjZxjbv8iFukEIQ+jCfj+Z95ueV+rX2R7bGuvT/wRPHK4ctNbxB9KQrx6/8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=c5xNDMhuyVoV1C2zdSMFkuJHZ5IrnK7cPNPuHVMqY3Frto2+3Nl87YMfpBktCEYI4D3iaHMJb6VLkg977U56UaskDOkVV3Mny4XNpBKb75xk5tPqqoCUFoEK6NgDOqtvDsmArEsEQ92ks/8RxW1pRwV8KgLC4j3Jo6IhpEjfiEA= Received: by 10.141.210.5 with SMTP id m5mr377491rvq.1187800080179; Wed, 22 Aug 2007 09:28:00 -0700 (PDT) Received: by 10.141.84.14 with HTTP; Wed, 22 Aug 2007 09:28:00 -0700 (PDT) Message-ID: <878c83960708220928j2cbc5d48qc34bcba009509a62@mail.gmail.com> Date: Wed, 22 Aug 2007 20:28:00 +0400 From: "Dmitry Potapov" To: "Kenneth Marshall" Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux Cc: pgsql-performance@postgresql.org In-Reply-To: <20070822155719.GJ26562@it.is.rice.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_83271_23362545.1187800080126" References: <878c83960708220833l72dbd461k827aea77ec7d6c32@mail.gmail.com> <20070822155719.GJ26562@it.is.rice.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/241 X-Sequence-Number: 26371 ------=_Part_83271_23362545.1187800080126 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 2007/8/22, Kenneth Marshall : > > > You are working at the correct level. The bgwriter performs the I/O > smoothing > function at the database level. Obviously, the OS level smoothing function > needed to be tuned and you have done that within the parameters of the OS. > You may want to bring this up on the Linux kernel lists and see if they > have > any ideas. Will do so, this seems to be a reasonable idea. -- Regards, Dmitry ------=_Part_83271_23362545.1187800080126 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline

2007/8/22, Kenneth Marshall <ktm@rice.edu>:

You are working at the correct level. The bgwriter performs the I/O smoothing
function at the database level. Obviously, the OS level smoothing function
needed to be tuned and you have done that within the parameters of the OS.
You may want to bring this up on the Linux kernel lists and see if they have
any ideas.

Will do so, this seems to be a reasonable idea.


--
Regards,
            Dmitry ------=_Part_83271_23362545.1187800080126--