Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TLxQR-0005Ax-Ob for pgsql-performance@postgresql.org; Wed, 10 Oct 2012 14:38:19 +0000 Received: from smtp.peak6.com ([38.98.137.6]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TLxQQ-000753-4a for pgsql-performance@postgresql.org; Wed, 10 Oct 2012 14:38:19 +0000 X-AuditID: 0a64cb1e-b7fd36d00000120f-a1-50758850606f Message-ID: <50758857.6030008@optionshouse.com> Date: Wed, 10 Oct 2012 09:38:15 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120912 Thunderbird/15.0.1 MIME-Version: 1.0 To: =?UTF-8?B?U3RyYWhpbmphIEt1c3R1ZGnEhw==?= CC: Subject: Re: shared_buffers/effective_cache_size on 96GB server References: <507573A4.1090605@optionshouse.com> In-Reply-To: Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Length: 783 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFuphleLIzCtJLcpLzFFi42LhSuEV0w3oKA0w+H+F1+L6zHPMFoceXGBz YPK4u0LW48K+aewBTFENjDaJeXn5JYklqQopqcXJtkr+BSWZ+XnFHvmlxakKLpnFyTmJmbmp RUoKmSm2SuZKCgU5icmpual5JbZKiQUFqXkpSnZcChjABqgsM08hNS85PyUzL91WyTPYX9fC wtRS11DJLh4ZJHSyZLzbc5il4DNLxe3NK9kbGL8zdzFyckgImEjcnradDcIWk7hwbz2QzcHB K6AvsfubF0iYRUBVov/YQSYQm01AV2JS/wqwciEBFYm+szfA4vwCwhL7PjSBjRQVCJN49+so K4jNKyAocXLmExYQW0TAVeLxo36wXmYBNYm5DyeB1QgLeEqsPPQVKM4FNHMno8SUP/vBGjgF AiUefdrEDNFgIbH4zUF2CFteonnrbGaII1QlVjRPhLpfQeL/lXdMExiFZiHZPQtJ+ywk7QsY mVcxiheXJSZnZJoWFOeWFBjqFaQmZpvp5aWWbGIEx+1puR2M05cqHmIU4GBU4uE1KCkJEGJN LCuuzD3EKMHBrCTCa+pTGiDEm5JYWZValB9fVJqTWnyIMRkYaBOZpUST84EpJa8k3tDY0NLU 0sTM0tzY2IA0YSVxXts+pQAhgXRg4slOTS1ILYLZwsTBKdXAOOPG1L1b+RPaf2xapp2pO5fz r0z6E9WDXmfz9ZN0Z6RHdTk9i2++xHXHd8J3k8wTRjttP3I/S3ldyv3qWWaMos2UPdm5GR8b 9DwvB08sWjapcvKuZo6NW44oCsj3Xdxh1HKbs1Be/F2qYeHcM5tiJ8arZ7wz8u27vFFARHmO n4X+Rctak7A5SizFGYmGWsxFxYkAqoiVKx8DAAA= X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201210/112 X-Sequence-Number: 48071 On 10/10/2012 09:35 AM, Strahinja Kustudi=C4=87 wrote: > #sysctl vm.dirty_ratio > vm.dirty_ratio =3D 40 > # sysctl vm.dirty_background_ratio > vm.dirty_background_ratio =3D 10 Ouuuuch. That looks a lot like an old RHEL or CentOS system. Change those ASAP. Currently your system won't start writing dirty buffers until it hits 9.6GB. :( > shows that these values are even higher by default. When you said > RAID buffer size, you meant the controllers cache memory size=3F Yeah, that. :) -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email