Re: Benchmarking a large server

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Greg Smith <greg(at)2ndQuadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmarking a large server
Date: 2011-05-10 17:50:40
Message-ID: 4DC97AF0.2050204@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith wrote:
> On 05/09/2011 11:13 PM, Shaun Thomas wrote:
>> Take a look at /proc/sys/vm/dirty_ratio and
>> /proc/sys/vm/dirty_background_ratio if you have an older Linux
>> system, or /proc/sys/vm/dirty_bytes, and
>> /proc/sys/vm/dirty_background_bytes with a newer one.
>> On older systems for instance, those are set to 40 and 20
>> respectively (recent kernels cut these in half).
>
> 1/4 actually; 10% and 5% starting in kernel 2.6.22. The main sources
> of this on otherwise new servers I see are RedHat Linux RHEL5 systems
> running 2.6.18. But as you say, even the lower defaults of the newer
> kernels can be way too much on a system with lots of RAM.

Ugh...we're both right, sort of. 2.6.22 dropped them to 5/10:
http://kernelnewbies.org/Linux_2_6_22 as I said. But on the new
Scientific Linux 6 box I installed yesterday, they're at 10/20--as you
suggested.

Can't believe I'm going to need a table by kernel version and possibly
distribution to keep this all straight now, what a mess.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre C 2011-05-10 17:56:03 Postgres NoSQL emulation
Previous Message Maria L. Wilson 2011-05-10 17:47:44 Re: help speeding up a query in postgres 8.4.5