Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 999FE1BA1319 for ; Thu, 5 Apr 2012 10:10:18 -0300 (ADT) Received: from nm14-vm0.bullet.mail.ird.yahoo.com ([77.238.189.193]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SFmS7-0002o7-Rb for pgsql-performance@postgresql.org; Thu, 05 Apr 2012 13:10:17 +0000 Received: from [77.238.189.234] by nm14.bullet.mail.ird.yahoo.com with NNFMP; 05 Apr 2012 13:10:01 -0000 Received: from [212.82.108.248] by tm15.bullet.mail.ird.yahoo.com with NNFMP; 05 Apr 2012 13:10:01 -0000 Received: from [127.0.0.1] by omp1013.mail.ird.yahoo.com with NNFMP; 05 Apr 2012 13:10:01 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 704262.50570.bm@omp1013.mail.ird.yahoo.com Received: (qmail 68875 invoked by uid 60001); 5 Apr 2012 13:10:01 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1333631401; bh=pdqmREHDjLsiDRTT11PL92tzz8kFZhgriKqCWdw3/UQ=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=H9e7Qatnr46lNFibeDddzM+8BMr8Sb2Tj1DCi69ZNKTEzmmNbWs5nH7+e8WD3KI0SKM7N6xYlItOEB8hhvNPY4IP415e2aKkE3PA70Riylpos7D0Kp79R2UluDV7ZJ5Q+MRiNnT0m6Kl3wvF30ydYFqOxpx3e7wLj3jA368ibrc= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=vH7UQmVvNAS4ilkbZZa1dncPhG1c2QfDjVp8KJWCZdQt9uNmu3vP5q3hnttHV9gsLSKKjc7yEbTcFOq919e1cHs8s9a0oN5xNQox/RU9ncFnTf4BK36TIkTc/zJDmVZQkB8E9+xatSvPosPrsTYvz2JTRcDevjKCG4rataZAArU=; X-YMail-OSG: 3mzcoxsVM1lT._KYCnr9KJgfN2sGY1w4nH9UmAkyDj6fjLK vDS_n3WAzfmp0KRTzwdzu15gIP.i.PVmu2H.gyj8cvk_w48Og40Z6r3IBSzI M7xrt8hUpjKzAXuRyLbzRvaq1TV4GHi0qKEXN8KpXhBH_HUIz6vwgRKCnJYb zcFlB_Ub1hWoCMhKWDDTyBtggFmYJi43nX5m_0KIUpZaA0XHK2acJN75vFnS 0M7G9YTDbttESqJfq4c4NvF7.4wEm7xsfj2lcrp2PkIhw48H7c38.fKEpS2S GkelLtNQfsbv6g.Yrwi2twGWZsM1ebvoRRmYediHQL5ChUh279ty6II8LvbF lddJ9n0kJIls7J7iqJZ95XB4D7ufMJMD.d9PBUrFAX7WiTR3yoT_vqGaVWi1 cnJ2tplzdY0nO7uMEQtRgav4KA2p_WP_WocAkIrbDGg-- Received: from [194.168.202.210] by web171401.mail.ir2.yahoo.com via HTTP; Thu, 05 Apr 2012 14:10:01 BST X-Mailer: YahooMailWebService/0.8.117.340979 References: <920BB532-C321-45A3-851E-8B688A5963F7@yahoo.com> <4F7AF966.20809@fuzzy.cz> <4F7B3AEC.4000204@fuzzy.cz> <4F7CA614.8060008@fuzzy.cz> Message-ID: <1333631401.49335.YahooMailNeo@web171401.mail.ir2.yahoo.com> Date: Thu, 5 Apr 2012 14:10:01 +0100 (BST) From: Glyn Astill Reply-To: Glyn Astill Subject: Re: H800 + md1200 Performance problem To: Tomas Vondra , "pgsql-performance@postgresql.org" In-Reply-To: <4F7CA614.8060008@fuzzy.cz> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-491639913-201178445-1333631401=:49335" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/56 X-Sequence-Number: 46702 ---491639913-201178445-1333631401=:49335 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > From: Tomas Vondra =0A=0A> But the fluctuation, that surely = is strange. What are the page cache=0A> dirty limits, i.e.=0A> =0A> cat /pr= oc/sys/vm/dirty_background_ratio=0A> cat /proc/sys/vm/dirty_ratio=0A> =0A> = That's probably #1 source I've seen responsible for such issues (on=0A> mac= hines with a lot of RAM).=0A> =0A=0A+1 on that.=0A=0AWe're running similar = 32 core dell servers with H700s and 128Gb RAM.=0A=0AWith those at the defau= lts (I don't recall if it's 5 and 10 respectively) you're looking at 3.2Gb = of dirty pages before pdflush flushes them and 6.4Gb before the process is = forced to flush its self.=0A ---491639913-201178445-1333631401=:49335 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
> From= : Tomas Vondra <tv@fuzzy.cz>
> But the fluctuation, = that surely is strange. What are the page cache
> dirty limits, i.e.<= br>>
> cat /proc/sys/vm/dirty_background_ratio
> cat /proc/= sys/vm/dirty_ratio
>
> That's probably #1 source I've seen res= ponsible for such issues (on
> machines with a lot of RAM).
> <= br>
+1 on that.

We're running similar 32 core dell servers with H= 700s and 128Gb RAM.

With those at the defaults (I don't recall if it= 's 5 and 10 respectively) you're looking at 3.2Gb of dirty pages before pdf= lush flushes them and 6.4Gb before the process is forced to flush its self.=
---491639913-201178445-1333631401=:49335--