Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 5B0C69F9744
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 22 Aug 2007 13:16:23 -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 93260-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 22 Aug 2007 13:16:18 -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.187])
	by postgresql.org (Postfix) with ESMTP id 508B49F9735
	for <pgsql-performance@postgresql.org>;
	Wed, 22 Aug 2007 13:16:18 -0300 (ADT)
Received: by rv-out-0910.google.com with SMTP id c24so148512rvf
	for <pgsql-performance@postgresql.org>;
	Wed, 22 Aug 2007 09:16:15 -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=mYUStCUZxeGAYLH0InSV2PsiajCTgWhs71ywc+j1Ihg2THb9YzP0ajf+DHrCpKWi8pmA25Tj/bxvEjNQp0F7ZdnO2xvS8pwcZsnk870UWeWU/nPiSQ+usi15n/noiHUJz27oV28L4vMOaxYHPeeSaElsCIF62uo/Rofm5lvy6qY=
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=tGRr34yAC4z/D/NMa4lx10f7wwrzuyhW9PY3l7uEu7/t4GTMEfI2jAw97AX9PZuEJoBZnILg87agdAfg6V6/numaNJm5g+uEndnAw7mgeMT3WzBDNjoVhiwx5Z5M5z5K091wqxpSXNP/EebyaQug8DARVFYxHamTtUv9NSLe5rk=
Received: by 10.141.133.14 with SMTP id k14mr376293rvn.1187799375182;
	Wed, 22 Aug 2007 09:16:15 -0700 (PDT)
Received: by 10.141.84.14 with HTTP; Wed, 22 Aug 2007 09:16:15 -0700 (PDT)
Message-ID: <878c83960708220916s393e8d93j42f7ae709ca074da@mail.gmail.com>
Date: Wed, 22 Aug 2007 20:16:15 +0400
From: "Dmitry Potapov" <fortune.fish@gmail.com>
To: "Mark Mielke" <mark@mark.mielke.cc>
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux
Cc: pgsql-performance@postgresql.org
In-Reply-To: <46CC5CED.2070001@mark.mielke.cc>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_83167_26943381.1187799375142"
References: <878c83960708220833l72dbd461k827aea77ec7d6c32@mail.gmail.com>
	<46CC5CED.2070001@mark.mielke.cc>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/239
X-Sequence-Number: 26369

------=_Part_83167_26943381.1187799375142
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

2007/8/22, Mark Mielke <mark@mark.mielke.cc>:
>
> Are you able to show that the dirty pages are all coming from postgres?
>
>
I don't know how to prove that, but I suspect that nothing else except
postgres writes to disk on that system, because it runs nothing except
postgresql and syslog  (which I configured not to write to local storage,
but to send everytning to remote log server). No cron jobs, nothing else.

-- 
Regards,
            Dmitry

------=_Part_83167_26943381.1187799375142
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

2007/8/22, Mark Mielke &lt;<a href="mailto:mark@mark.mielke.cc">mark@mark.mielke.cc</a>&gt;:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Are you able to show that the dirty pages are all coming from postgres?<br><br></blockquote></div><br>I don&#39;t know how to prove that, but I suspect that nothing else except postgres writes to disk on that system, because it runs nothing except postgresql and syslog&nbsp; (which I configured not to write to local storage, but to send everytning to remote log server). No cron jobs, nothing else.
<br clear="all"><br>-- <br>Regards, <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dmitry

------=_Part_83167_26943381.1187799375142--